I want to link totals on multiple worksheets into one total

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

 

[hugablek]

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.

 

[hugablek]

I put all the subtotals in the same cell on each worksheet and followed the
directions and it still gives me an error message.

 

[Gord Dibben]

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