Function for multiple tabs in one worksheet

  • Thread starter Thread starter Excel makes life easier
  • Start date Start date
E

Excel makes life easier

I have a standard template for all tabs in one workbook (there are about 100
different tabs). What is the function to sum the same cells in each tab and
carry over to a summary leadsheet?

Would this be similar to running a report?

Thank you!
 
Assume that your summary sheet is not contained within the "sandwich"
made up of the "first" sheet and "last" sheet, and that you want to
add every E5 cell from the sheets. Here's the formula you need in your
summary sheet:

=SUM(first:last!E5)

Change those names to suit your sheet names - if you have spaces in
the sheet names you will need to put apostrophes around them:

=SUM('first sheet:last sheet'!E5)

Hope this helps.

Pete
 
=SUM(Sheet2:Sheet100!A1)

Entered in a cell on Summary leadsheet.

If your sheetnames are unique then the best course is to insert a new sheet
just right of Summary and insert a new sheet after last sheet.

Name these First and Last

=SUM(First:Last!A1)

When adding more sheets insert them anywhere between Fiest and Last


Gord Dibben MS Excel MVP
 
Back
Top