Totalling across sheets

  • Thread starter netnews.comcast.net
  • Start date
N

netnews.comcast.net

I have a workbook that helps keep tabs on properties that I buy and sell.
Each sheet is exactly the same as the other with the exception of the top
sheet which is to serve as a totals sheet and is named "Totals". I have
named the last sheet "Final." I would like cell C16 of the totals sheet to
be the total of all C16 cells on all of the other sheets, even if I add or
remove sheets as I buy and sell properties. I have tried using the
INSERT>NAME>DEFINE route and keep getting errors when I attempt to create
the formula, even while trying to follow Microsoft Excels Help file. Any
help would be appreciated.
 
J

JulieD

Hi

one way
insert a sheet after the totals sheet and call it FIRST
click in cell C16 of the TOTAL sheet and type
=SUM(first:final!c16)

now when you buy & sell make sure that you place all the sheets between the
first & final sheet
and the total will always be the total of your current properties

Regards
JulieD
 
Top