98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course london - Merge data from two sheets using dsum function? | Excel forum
excel training course london - Merge data from two sheets using dsum function? | Excel forum
Resolved · Low Priority · Version Standard
Thu 30 Nov 2006, 10:16Delegate 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:55Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Status Bar FunctionsWhen using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet. |
