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?

Obviously this could be done in the tedious process of
"=+Jan!D15+Feb!D15....+Dec!D15 but this can't be readily copied to another
cel without requiring major editing.

LOTUS 123 had such a feature if anyone remembers that software. I do not
recall the exact commands but it was possible to sum a cell or range of cells
over a range of sheets with a simple command string that could be copied to
sum other cells without having to write a equation as above.