how to sum up the c13 cells in all of the sheets in a workbook
 

I am developing a master work sheet that incorperates several sheets of
simular info. need a way to total the sums of each sheet. and to be able to
have the formula be expandable for new information to be added. ie: adding
all the "c13" cells in all the sheets of a workbook.
stuck
in a rut

how to sum up the c13 cells in all of the sheets in a workbook
 

Insert a new sheet to the immediate left of the first sheet you want to
include in the sum. Name this sheet Start. Insert a new sheet to the
immediate right of the last sheet you want to include in the sum. Name this
sheet End.

Then:

=SUM(Start:End!C13)

If you create new sheets and want them to be included in the sum just insert
them between the Start sheet and the End sheet. Any sheet between the Start
sheet and the End sheet will be included in the sum.

--
Biff
Microsoft Excel MVP


"Liz" wrote in message
...
I am developing a master work sheet that incorperates several sheets of
simular info. need a way to total the sums of each sheet. and to be able
to
have the formula be expandable for new information to be added. ie:
adding
all the "c13" cells in all the sheets of a workbook.
stuck
in a rut