totalling across pages
 

I have multiple pages, each reprresenting a single property that I own. The
topmost page is named "Total" and the final page is named "99". Each
property is named differently, depending on the property number that I have
given it. Each page is exactly the same. On each page is a cell, (C3),
that is the "total cost." I would like to have the top sheet, named "Total"
automatically add all of the C3's on every page and show the total. I would
also like to be able to add blank pages before page "99" and have all the
formulas work without doing any changes. How do I do this?

totalling across pages
 

Hi
try
=SUM('first_sheet:sheet99'!C3)


--
Regards
Frank Kabel
Frankfurt, Germany

"netnews.comcast.net" schrieb im Newsbeitrag
news:HhALc.158063$XM6.148212@attbi_s53...
I have multiple pages, each reprresenting a single property that I
own. The
topmost page is named "Total" and the final page is named "99". Each
property is named differently, depending on the property number that
I have
given it. Each page is exactly the same. On each page is a cell,
(C3),
that is the "total cost." I would like to have the top sheet, named
"Total"
automatically add all of the C3's on every page and show the total.
I would
also like to be able to add blank pages before page "99" and have all
the
formulas work without doing any changes. How do I do this?