"JE McGimpsey" wrote:

one way:

=SUM('Jan:Dec'!D15)

In article ,
Bill wrote:

Anyone know how to write a command to add common cells across mutiple sheet?

Example: I would like to add the contents of cell D15 form individual sheets
Jan, Feb, Mar, ..... Dec.

Is there a way to set the range across sheets just as is possible across
cells in a single sheet?

THANKS for the great reply!!! I too am an old Lotus user and just spent too
many minutes trying to do this function with my new Excel program ....
sheesh, so easy once you see a fabulous example!