I wonder if you could help me. I have a similar issue. However I would like
to summ a running total where the cell will cahnge as entries are added.

"InsomniacFolder" wrote:

Hello,
Is there a way to do this and included non contiguous sheets also?

e.g.the equivalent of =SUM(Sheet1:Sheet4,Sheet7,Sheet9!A1:A10) etc

To find the totals of A1:10 in sheets 1,2,3,4,7,9 of a workbook.

I can do it the long way round,
=SUM(Sheet1:Sheet4!A1:A10,Sheet7!A1:A10,Sheet9!A1: A10) but when using a
formula, I cannot use CTRL to select a standalone sheet, thouhg you can when
selecting multiple sheets not in a formula

With the number of sheets available in Office 2007, linking all the cells
across (very badly designed, but unfortunately sacrosanct) workbooks each tme
gets tedious.

Thankyou kindly
KeLee


"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.