Adding accross several sheets in the same workbook

[Vaughje]

I have a spreadsheet with 30 tabs. Each tab has the exact same format (income statement). I need to add all of the tabs togeather on summary sheet. There has to be an easier way then mannually selecting each cell.

Thanks

 

[Cbrine]

=SUM(Sheet1:Sheet6!A1)

This forumla will add the Values of A1 on Sheets1 to 6.

You should be able to use this example to figure out how to build your summary.

 

[shades]

If you will only be using SUM, and the number of sheets changes, then insert two new worksheets, one labeled First, then other Last. Put all the other sheets that you want added between them, then modify the given formula to:

=SUM(First:Last!A1)

This makes it easier to "What If" scenarios by moving sheets outside of First or Last.