I want to link totals on multiple worksheets into one total

  • Thread starter Thread starter hugablek
  • Start date Start date
H

hugablek

I have a workbook that has multiple pages. I want to link each subtotal on
each worksheet to a grand total at the end of the workbook. I have tried
different things and have not been able to accomplish it. Can someone help
me with it.
 
They are not in the same cell at this point but I can make them the same cell
number. If I had information, will the information continue to update? The
information you have given is helpful so far and I'll try that. Thanks.
 
I put all the subtotals in the same cell on each worksheet and followed the
directions and it still gives me an error message.
 
Are your sheetnames the standard sheet1, sheet2 etc. or unique names?

One way around unique names is to add a dummy sheet at the beginning then
add a dummy sheet before Summary sheet.

Name these Start and End.

Formula in Summary sheet is then =SUM(Start:End!H12)

When inserting new sheets, insert between Start and End.


Gord Dibben MS Excel MVP
 

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

Multiple Grand Total Lines 1
Grand totals on another worksheet. 1
Spreadsheet summary automatically referrences totals of worksheets 2
How do I find like data in multiple worksheets? 1
Totals of different worksheets. 2
Totaling cells in multiple worksheets 4
Linking Totals Across Multiple Worksheets 2
Totaling from seperate worksheets 1

Back
Top