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

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

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
 
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.
 
Back
Top