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

On Feb 17, 10:51*pm, Excel makes life easier <Excel makes life easier
@discussions.microsoft.com wrote:
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!

=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

On Wed, 17 Feb 2010 14:51:02 -0800, Excel makes life easier <Excel makes
life easier @discussions.microsoft.com wrote:

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!