Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resolved my query regarding total sum calculating
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resolved my query regarding total sum calculating
Hi Tushar
Maybe =SUM(Sheet2:Sheet3!A1) where A1 is the cell reference on the Sheets that holds your Subtotals -- Regards Roger Govier "tushar" <tushar @discussions.microsoft.com wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use the IF function to resolved more than one creteria | Excel Worksheet Functions | |||
Averaging Problem Still Not Resolved - DailyMoodTrTool.xls (1/1) | Excel Discussion (Misc queries) | |||
Please-please-HELP - Really need this resolved - Allocation formul | Excel Worksheet Functions | |||
calculating total time | Excel Discussion (Misc queries) | |||
I think I found a bug and need to kow how to get it resolved | Setting up and Configuration of Excel |