Totaling from seperate worksheets
 

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.

Totaling from seperate worksheets
 

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.