Excel 2007 : Summing totals on different worksheets

**Richard Buttrey** · 08-20-2011, 07:05 AM

Hello,

I don't understand what you're asking.

Please show the result you expect to see on a second sheet and explain how the results are arrived at.

Regards

**Chainsaw_019** · 08-20-2011, 07:52 AM

Attached is the worksheet sample..There is a supplementary for the month of november but it i submitted on December..I want to add the total of the supplementary to the total of november sheet..Pls. Help me..It would be much appreciated.

**Richard Buttrey** · 08-20-2011, 10:39 AM

Hi,

What do you mean by add the total? Do you mean you want to add the 50 in Sheet2 AE14 to the total 176 in Sheet1 AG3?

If not please add a result sheet as requested to show exactly what you want to see.

Regards

**Chainsaw_019** · 08-20-2011, 10:56 AM

Yes sir...that was exactly what i want to see..

**Richard Buttrey** · 08-20-2011, 11:46 AM

Hi,

In that case in AG3 on Sheet 1

=SUM(A3:AD3)+Sheet2!AE14

and copied down as necessary.

Regards

Excel 2007 : Summing totals on different worksheets

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Summing totals on different worksheets

Re: Summing totals on different worksheets

Re: Summing totals on different worksheets

Re: Summing totals on different worksheets

Re: Summing totals on different worksheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions