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
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