How do I add totals from more then 1 worksheet together

T

Techman1960

I'm making a worksheet that has 2 or 3 pages to it. I want to know how I can
have a running total that carries over from sheet to sheet . In other words
as I fill in the first sheet, it totals at the bottom (I know how to do
that), but then as I add figures to the second sheet, I want it to total at
the bottom also, with the figures from the first sheet.and so on for the
third shet. For example, Page 1 + Page 2 + Page 3. I hope that you can
understand my question.

Thanks in advance for your help
Phil
 
K

keithl816

Assuming totals were in cell a1 in all three sheets

In sheet 2

=sum(sheet1!a1+a1)

In sheet 3

=sum(sheet1!a1+sheet2!a1+a1)



Hope this helps
 
T

Techman1960

keithl816 said:
Assuming totals were in cell a1 in all three sheets

In sheet 2

=sum(sheet1!a1+a1)

In sheet 3

=sum(sheet1!a1+sheet2!a1+a1)



Hope this helps


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21287
View this thread: http://www.excelforum.com/showthread.php?threadid=375980

Keith, thanks for your reply. I tried to put your formulain, but I got an error. It came up with a value error. On my work sheets I renamed them Page 1 of 1, Page 2 of 2, and so on. If this makes a difference. I have a totals line on line 43, or otherwords C$# on all three sheets. I also have 2 more, but I should be able to do those ones on my own.
Click to expand...
TRhanks again for your help.
Phil
 
K

keithl816

In your sheet tabs change the sheet name to Page1of1, and so on with th
rest of the sheets, remove any spaces between words and numbers as show
below

In sheet 1 change tab to read Page1of1

Totals in Cell C43

In sheet 2 change tab to read Page2of2

Totals in cell C43

=sum(Page1of1!c43+c43)

In sheet 3 change tab to read Page3of3

Totals in Cell 43

=sum(Page1of1!c43+Page2of2!c43+c43)


Hope this help
 
Top