Sum Across Multiple Sheets

A

aks1983

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|
+-------------------------------------------------------------------+
 
P

Per Jessen

Hi

Your formula shall look like this:

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

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum multiple worksheets and summary tab that would sum and count by rep name 0
Vary sheet name & sum across multiple sheets 3
Sum several sheets 3
SUM/COUNTIF across multiple worksheets 7
Can a SUMPRODUCT array formula be used across multiple worksheets? 0
Sorting Data from ont sheet to several sheets 11
Sum formula across multiple tabs and fields 5
Formula to get sum from one 31 sheets to a summary sheet. 7

Top