Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding subtotals from several worksheets
I am trying to figure out how to create a "Grand Total" on my final worksheet
containing the sum of subtotals from several previous worksheets. Such as, cell O33 from worksheet1, cell O44 from worksheet2, cell O58 from worksheet5....etc.... not sure where to even find a HELP item on this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding subtotals from several worksheets
Here's a *REMOTE* possibility making *a lot* of assumptions**:
If these cells are SUMS then there's a good chance** that these values are the max values in those columns. Your sheet names follow some kind of sequential pattern** like Sheet1, Sheet2, Sheet3, etc. The sheets you want totaled are a contiguous block** like SUM(Sheet1,Sheet2,Sheet3), not like SUM(Sheet1,Sheet5,Sheet22) Based on all of those improbable assumptions, this formula will sum the max values from sheet's 1:3 column O: =SUMPRODUCT(SUBTOTAL(4,INDIRECT("sheet"&ROW(INDIRE CT("1:3"))&"!O:O"))) -- Biff Microsoft Excel MVP "bernieb" wrote in message ... I am trying to figure out how to create a "Grand Total" on my final worksheet containing the sum of subtotals from several previous worksheets. Such as, cell O33 from worksheet1, cell O44 from worksheet2, cell O58 from worksheet5....etc.... not sure where to even find a HELP item on this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding subtotals from several worksheets
Type an = sign in the cell where you want your Grand Total, then go to the
first sheet and click in the relevant cell to add, then type + sign, then click in the relevant cell on the next sheet, then another plus sign, on until you get to the cell on the last sheet, and enter. You should end up with a formula like =Sheet1!O33+Sheet2!O44+Sheet5!O55 -- David Biddulph "bernieb" wrote in message ... I am trying to figure out how to create a "Grand Total" on my final worksheet containing the sum of subtotals from several previous worksheets. Such as, cell O33 from worksheet1, cell O44 from worksheet2, cell O58 from worksheet5....etc.... not sure where to even find a HELP item on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding worksheets | Excel Discussion (Misc queries) | |||
Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
Subtotals adding a description next to the subtotals | Excel Worksheet Functions | |||
How do I save & apply sorts subtotals in excel to new worksheets? | Excel Discussion (Misc queries) | |||
adding worksheets together | Excel Discussion (Misc queries) |