adding cells in multiple worksheets

  • Thread starter Thread starter Hrider
  • Start date Start date
H

Hrider

I am looking for the command that will add together an amount from multiple
worksheets in a workbook from the same cell reference, for example, b4 from
sheet 1 and b4 from sheet 2 and b4 from sheet3. I am working on a large
worksheet and do not want to "tag" each one to build my formula.
 
Hrider

With your Grand Total sheet first in workbook.

In a cell enter =SUM(sheet1:sheet3!B4)

Alternative, which most prefer and lends itself to flexibility in naming,
deleting and moving sheets.

Insert a dummy sheet to the right of the Grand Total sheet. Name it Start

Insert a dummy sheet at end of sheets. Name it End.

In Grand Total sheet enter =SUM(Start:End!B4)

When inserting new sheets make sure they are inserted between Start and End
sheets.


Gord Dibben Excel MVP
 
Back
Top