View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default 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.