Adding extra sheets to a formula

J

Jamie

Hi There

I have a spreadsheet and I would like to do a simple
formula that adds say Sheet1!A1+Sheet2!A2 .. Sheet30!A2.

I can do this no problem. My trouble is that this
spreadsheet is updated daily with new worksheets and I
would like a way of making the formula add all the A2's in
each worksheet automatically.

Is there any way of doing this without having to manually
change the formula to include the new sheets?

Thanks in advance

Jamie
 
F

Frank Kabel

Hi
try the following:
- insert a start and an end sheet
- only insert new sheets between thos two sheets
- use the following formula:
=SUM('sheet_start:sheet_end'!A2)
 
Top