Sheets

B

Bert

Hi,
I have 3 sheets of many items with a column of prices. I have a sub total
of the cost at the bottom of each sheet. That is simple.
I would like the bottom of the third sheet to calculate the total value of
the sub totals of the 3 sheets.
How can I identify the sub totals of each of the 3 sheets so that the
bottom of the third sheet would calculate the total cost?
Thanks
Bert
 
B

Bert

Hi
The cell e46 in sheet 1 has a formula. It is =sum(i3:i38) ie. $34500.
The cell e53 in sheet 2 has a formula. It is =sum(i3:i39) ie. $44500.
Similar for sheet 3.
Does that help?
 
F

Frank Kabel

Hi
the question is: How do you identify the position of these subtoptal
cells. e.g. do you have a label such as
'Total' in cell D46 and D53 respectively
 
T

tghcogo

oops, missed sheet 3

total on third sheet should be:-

='sheet1'!E46+'sheet2'!E53+sum(I3;I39)

hope this helps
 
Top