Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to add the grand totals from my multiple worksheets, within the same
workbook, together onto another worksheet...I can't for the life of me remember what it is called or how to do it. Any information would be appreciated, even what it is called and then I can look it up. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If the grand totals are in the same cell on their respective worksheets, you
can use a '3D sum' to pull the total back: =sum(Sheet1:Sheet3!A1), for example, will sum all A1s on worksheets Sheet1 through Sheet3, inclusive. "cgauvreau" wrote: I want to add the grand totals from my multiple worksheets, within the same workbook, together onto another worksheet...I can't for the life of me remember what it is called or how to do it. Any information would be appreciated, even what it is called and then I can look it up. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create chart with data from across seperate worksheets | Charts and Charting in Excel | |||
Create single chart with data from seperate worksheets | Charts and Charting in Excel | |||
how do you create a daily diary using seperate worksheets? | Excel Discussion (Misc queries) | |||
How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
Totaling Cells in Worksheets | Excel Worksheet Functions |