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

The UK's most regular instructor-led training courses.
Training information: excel training course london · Excel-courses-london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Merge data from two sheets using dsum function?

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

by - delegate Maria [1 post] (2006 Nov 30 Thu, 10:16) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: merge data from two sheets using dsum function?

by - trainer Orok bronze contributer [29 posts] (2006 Dec 1 Fri, 11:55) Reply

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

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Advanced Excel Training - takes you to the next level
· Fun Things I've Done With Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Features of Microsoft Excel that assist in Analysis of Financial Data

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips