excel training course london - Merge data from two sheets using dsum function? | Excel forum

Resolved · Low Priority · Version Standard

Thu 30 Nov 2006, 10:16 Delegate Maria said...

Maria has attended:
Excel Advanced course
Excel Intermediate course
Excel Advanced course

Merge data from two sheets using dsum function?

I wish to add numbers from two sheets with same numeric referencing. I think I can use dsum function but am unsure. Perhaps you can point me to correct function and formula. Sheet 1) I have three columns, column 1 is static numeric reference, column 2 is name to column 1, column 3 is data which I wish to capture. Sheet 2) is sames format as 1). Many thanks in advance. Maria

Fri 1 Dec 2006, 11:55 Trainer Orok said...

RE: merge data from two sheets using dsum function?

Hi Maria,

When I read your question the solutions seems to be a straightforward summation of two worksheets. Apologises if I am over simplifying the problem

In the summation worksheet, apply the following

=SUM(Sheet1!Name1Data,Sheet2Name1Data)

Copy down for all other rows

Hope this is of assistance

Regards

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips