Thread
:
Totalling across sheets
View Single Post
#
3
Posted to microsoft.public.excel,microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Totalling across sheets
Didn't you ask this yesterday?
Have you tried
=sum(sheet2:final!c16)
--
Don Guillett
SalesAid Software
"netnews.comcast.net" wrote in message
news:VmQLc.5019$eM2.2395@attbi_s51...
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.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]