Summing same cells in multiple worksheets

[neilcarden]

Hi,

I have a monthly workbook which consists of a worksheet for each day
These sheets are named 01, 02, 03 etc up to 31.

I also have a monthly totals worksheet. I want to sum certain cells o
each sheet to show in the monthly sheet....

eg ='01'!E7+'02'!E7+'03'!E7.......

Is there a quick way of creating this formula without manually typin
it in?

Thanks in advance
Nei

 

[Gord Dibben]

Easiest method is to create a sandwich with the sheets as the filler.

Assuming Summary sheet is first in workbook.

Insert a dummy sheet to the right of Summary sheet..........name it Start

Insert a dummy sheet at end..........name it End

In your summary sheet =SUM(Start:End!E7)

When adding new sheets insert them between Start and End.

Sheetnames can be anything.


Gord Dibben MS Excel MVP