Sum the same cell across multiple sheets

[mazzonem002]

I"m adding the same cell on multiple sheets to total up on my "total sheet". Is there a simple formula to put on the "total sheet" that will work? I can use ='sheet1'!B1+'Sheet2'!B1+'Sheet3'!B1+etc. The problem is I have 200 sheets and I know there must be an easier way.

[jeffreybrown]

Add two new sheets, First and Last and then place all sheets in-between these two sheets and...

=SUM(First:Last!B1)

[mazzonem002]

That worked I didn't have it exactly as you listed it.

[mazzonem002]

Thanks Jeff

[jeffreybrown]

You are very welcome, glad we could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.