multiple worksheet formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
=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?
 
Back
Top