I'm having the same problem as Tony. My formulas are suddenly not working.
I've turned calculate auto and manual. tried saving, closing & reopening
file & still the =sum(...) formulas aren't working.