Sum Across Multiple Sheets
 

Dear all,

Please find the attached demo file.

On the summary page Cell B5,there is a sum function which is linked to
first three pages.i just want to extend that formula to the balance
work sheets also,but it should not count the page in between
ie,summary (21 - 31).the formula should be like this

=SUM('29:4'!C5) but as i mentioned earlier it should exclude the
summary(21-31) sheet.

Thanks In Advance,

Aks


+-------------------------------------------------------------------+
|Filename: Demo2.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=123|
+-------------------------------------------------------------------+

--
aks1983
------------------------------------------------------------------------
aks1983's Profile: http://www.thecodecage.com/forumz/member.php?userid=283
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93627

Sum Across Multiple Sheets
 

Hi

Your formula shall look like this:

=SUM(Sheet1:Sheet3!B1)+Sheet6!B1

Regards,
Per

"aks1983" skrev i meddelelsen
...

Dear all,

Please find the attached demo file.

On the summary page Cell B5,there is a sum function which is linked to
first three pages.i just want to extend that formula to the balance
work sheets also,but it should not count the page in between
ie,summary (21 - 31).the formula should be like this

=SUM('29:4'!C5) but as i mentioned earlier it should exclude the
summary(21-31) sheet.

Thanks In Advance,

Aks


+-------------------------------------------------------------------+
|Filename: Demo2.xls |
|Download:
http://www.thecodecage.com/forumz/attachment.php?attachmentid=123|
+-------------------------------------------------------------------+

--
aks1983
------------------------------------------------------------------------
aks1983's Profile: http://www.thecodecage.com/forumz/member.php?userid=283
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93627