Totaling from seperate worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Seperate worksheets 1
I want to link totals on multiple worksheets into one total 3
Totaling cells in multiple worksheets 4
Totals of different worksheets. 2
How do I find like data in multiple worksheets? 1
Copy formula from one worksheet to another to get value in 2nd wks 1
Multiple Grand Total Lines 1
running total 2

Back
Top