Excel 2007 : Summing totals on different worksheets

**Chainsaw_019** · 08-20-2011, 06:31 AM

I've attached a sample of my worksheet..I would like to know if there is a way to total the sum from supplementary adding to the total to october sheet with the same format of the november sheet...Please help.

**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

**Chainsaw_019** · 08-21-2011, 01:06 AM

Thanks...It really helps..

Excel 2007 : Summing totals on different worksheets

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

Re: Summing totals on different worksheets

Re: Summing totals on different worksheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions