Sam,
Thank you. Yes, the cell is in the same location on each sheet.

I tried it =SUM('08-09 ED PYMNTS IN 09-10'!H3:'09-10-FSCL ADMN-BGPMNT IN
09-10'!H3) and got VALUE as an answer. Did I do something incorrect?
--
Thank you for your help
MO
Albany, NY


"Sam Wilson" wrote:

=SUM(Sheet2:Sheet26!A1)

would work if your cell is in the same location on each sheet.

Sam

"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