If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|