multiple worksheet formulas

[Guest]

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!

 

[Domenic]

Try something like...

=SUM('Sheet2:Sheet17'!A2)

Hope this helps!

 

[Guest]

thank you for your support, but it doesn't seem to work. Any other ideas?

 

[DS-NTE]

=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?

 

[Guest]

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

Cory