Adding accross several sheets in the same workbook

Vaughje

New Member
Joined
Jan 22, 2004
Messages
1
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
=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

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,918
Messages
5,545,025
Members
410,647
Latest member
bernardazar
Top