If that one cell to be summed is the SAME cell in each sheet,
then a "sandwich" method like this would work

Insert 2 new sheets, name them simply as: x, y
Move x to be leftmost sheet, y to the extreme right of the 26 sheets to be
summed
Then in your summary sheet (which has to be outside of the x-y sandwich)
you could use eg: =SUM(x:y!B2)
to return the sum of cell B2 in all 26 sheets
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"MO" wrote:
Hope someone can help this poor soul!

I have 26 worksheets on one workbook that I need to add one cell from EACH
worksheet. When I try to add them all, there isn't enough room in the
formula box (it covers the formula and I can't choose the cell).

Do you know a way to accomplish this?
--
Thank you for your help
MO
Albany, NY