Sheets

  • Thread starter Thread starter Bert
  • Start date Start date
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
 
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?
 
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
 
oops, missed sheet 3

total on third sheet should be:-

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

hope this helps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for summing cells that may be deleted 4
Copy formula from various sheets 2
Complex value lookup? (Excel 2003) 6
extract data from multple worksheets to a summary worksheet 2
Subtotaling one sheet on another sheet 3
macro help on mid 3
Lock location of sheet within a spreadsheet 4
How do I sum numbers based on other data 6

Back
Top