I like this one on sheet 25
=SUM('*'!A20)


See also the last part of this page
http://www.rondebruin.nl/linksum.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JasonK" wrote in message ...
TIA

I've got a workbook with 25 sheets. I need a cell in the 25th sheet
to sum the same cell in each of the other 24. I can't figure out a
quick way to write a formula for that. Does anyone know?


I tried to Insert Name and Define and the reference, but I couldn't
make it work. My guess was I was doing it all wrong.

Thanks again,

JasonK