Sum Muliple Worksheets

  • Thread starter Thread starter Dru
  • Start date Start date
D

Dru

I have 8 indentical worksheets all labeled "Option YR X"

"X" being one of the eight years

Is there a way to add a 9th page that is a duplicate of all the others
and have each cell sum what is in the year 1-8 worksheets.

so the 9th page would sum everything in Option YR 1-8 for cell O23.


I guess my point is that I dont want to have some long drawn out
equation for this like ='Option Year 1'!O23+'Option Year 2'!O23... and
so on.

can you write something that points at the worksheets and then just
lists a cell to reference in everyone?

Thanks

Dru
 
Hi Dru

assuming that your 8 sheets are in order use the following
=SUM('YR 2000:YR 2008'!O23)

Frank
 
Back
Top