View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default SUM function working improperly

Sounds like you're in manual calculation mode. Press shift+F9. See if the
result changes. If so, put Excel in Automatic mode.

"streaker6" wrote in message
...
I have a function that is =SUM(A32:A113) in cell K194, simple right? Well
not
so much, it should be totalling up 67 and is showing 48, if I try to
change
the formula, the formula is what shows in cell K194...what's going wrong?
I
have other formulas giving me the same problems in the worksheet.

Thanks