Need help with formula

J

Just Me

I have a workbook that has about 20-30 worksheets in it. There is one column
in every worksheet that has a total, is there a way to have all the totals
from the worksheets show up on one worksheet as a grand total.

Thanks in advance
 
D

doodle

If the sheets were named 1-30, and your cell with total was A1, use
this formula:

=SUM('1:30'!A1)


-doodle
 
R

Roger Govier

Hi

Insert 2 new sheets. Name one as first the other as last.
Drag them to positions which encompass the range of 30 sheets you want
total, with your summary sheet outside of this "sandwich".
=SUM(First:Last!A100) or whatever cell on each sheet is holding your
column total.
Moving the positions of first and last will allow you to summarise
whatever range of sheets you want, without having to change the formula.
 
Top