thank you ds-nte, it worked. I must have typed it in wrong earlier!

Cory

"DS-NTE" wrote:

=SUM('Sheet2:Sheet17'!A2) sums the cells A2 in Sheet2, Sheet3,
Sheet4...Sheet17, it may also be written like this:
=Sheet2!A2+Sheet3!A2+Sheet4!A2+...+Sheet17!A2

What are your data and how are they organised?
What result do you get?
What result do you expect?
What doesn't seem to work?


"cory" skrev i melding
...
thank you for your support, but it doesn't seem to work. Any other ideas?

"Domenic" wrote:

Try something like...

=SUM('Sheet2:Sheet17'!A2)

Hope this helps!

In article ,
cory wrote:

Is it possible to do simple "sum" formulas using multiple worksheets? I
am
doing a football pool so I have 17 identical sheets and I would like to
add
the totals from each sheet to 1 sheet. Thank you for your cooperation!