Summing same cells in multiple worksheets
 

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 on each sheet to show in the monthly sheet....

eg Cell E7 on the monthly totals should equal ='01'!E7+'02'!E7+'03'!E7.......'31'!E7

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

Thanks in advance
Neil

Summing same cells in multiple worksheets
 

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


On Tue, 8 Jul 2008 23:16:48 +0100, neilcarden
wrote:


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 on
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 typing
it in?

Thanks in advance
Neil