Resolved my query regarding total sum calculating

  • Thread starter Thread starter tushar
  • Start date Start date
T

tushar

Hi

Please suggest to for this trouble E.g. in excel sheet I have update total
sum 500 in sheet no 2) update total sum 500 in sheet no 3 So, I would like
total sum from sheet 2 and sheet 3 in appear in sheet no1 in excel sheet.

Regards,
Tushar Patel
 
Hi Tushar

Maybe
=SUM(Sheet2:Sheet3!A1)
where A1 is the cell reference on the Sheets that holds your Subtotals
 
Hi Tushar

Maybe
=SUM(Sheet2:Sheet3!A1)
where A1 is the cell reference on the Sheets that holds your Subtotals
 

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

How do I sum numbers based on other data 6
Formula needed for adding every nth column on another sheet 6
Auto fill across multiple worksheets 3
Summary from multiple sheets 1
vlookup of sub totals 2
Help with a formula (Multiple lines to sum and return if) 2
How to Display 12.5 but not 25.0 (drop .0’s) 5
turning text into a calculated result: 3

Back
Top