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
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,817
Messages
5,772,456
Members
425,760
Latest member
paphon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top