View Single Post
  #2   Report Post  
paul
 
Posts: n/a
Default

should be written as Sum(G3:I3).If you hit F9 does it work?If it does you
have inadvertently set calculation to manual go to
toolsoptionscalculation,set caclulation to automatic.
--
paul
remove nospam for email addy!



"Lollycat" wrote:

I have the cells formatted for numbers and the formula is too simple to mess
up =SUM(G3-I3) but it simply won't calculate! What am I doing wrong?

Thank you in advance.