Totalling across sheets
Hi
one way:
- create a start and an end sheet (e.g. name them 'start'
and 'end' and also hide them if you like)
- only insert new sheets BETWEEN these two sheets
- Use the formula
=SUM('start:end'!C16)
-----Original Message-----
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
INSERTNAMEDEFINE 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.
.
|