Rat

Enter in your Grand Total cell in sheet1.

=SUM(sheet2:sheet5!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

On Tue, 20 Sep 2005 08:42:03 -0700, Ratman
wrote:

I have a worksheet for each month and a Year total worksheet. I would like
to sum up the corresponding monthly values into the same cell on the Year
total worksheet. I seem to recall that there is a simple way to do this
but...it's been more that 10 minutes ago.