The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course london - Merge data from two sheets using dsum function?

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

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

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

For upcoming training course dates see: Pricing & availability

ReplyFri 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

Excel articles

· Microsoft Office and the Small Business: Part 1 Excel
· How Sharing Your Excel Data Can Help Your Business Flourish
· How To Make Excel Open A Particular File When It Launches
· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· How To Embed Fonts In Excel

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips

Hi,

i know there is a quick and easy way of doing this without going into each one adn deleting it, i was just wondering if you could help me.

I have exported some data into excel and now in each cell the data is seperated buy "" i.e. &quo..

» Forum post: Removing " from a cell

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions