MrExcel Publishing
Your One Stop for Excel Tips & Solutions

automatic sum of tabs in worksheet

Posted by George on February 01, 2001 8:41 AM

say i have (3) identical P/Ls for departments A,B and C rolling up to total company. normally i would +a1 (A)+ a1 (B) and + a1 (C) to get total company. lets say now we just bought another company with departments D, E and F. is there an easier way instead of + departments A .....F. maybe a sum accross all worksheets so if i add new worksheets my total will continue to be updated.

Posted by Mark W. on February 01, 2001 9:07 AM

Yes, take a look at the Excel Help Topic for
"3-D references".

Posted by Celia on February 01, 2001 5:11 PM

Add two blank sheets. Name one of them "Start" and keep it as the first sheet in the workbook. Name the other one "End" and keep it as the last sheet.
To sum across all sheets use =SUM(Start:End!A1).
When adding new department sheets, insert them between sheets "Start" and "End".