Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training course london - merge data two sheets

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 training course london - Merge data from two sheets using dsum function?

ResolvedVersion Standard

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







Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.