adding cells in multiple worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hrider - 30 Jun 2005 22:54 GMT

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.

Reply to this Message

Bill Kuunders - 30 Jun 2005 23:22 GMT

something like......

=SUM(Sheet1:Sheet3!B4)
should work

Signature

Greetings from New Zealand
Bill K

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

Reply to this Message

Gord Dibben - 30 Jun 2005 23:36 GMT

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

Reply to this Message