My formula won't calculate

L

Lollycat

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.
 
P

paul

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
tools>options>calculation,set caclulation to automatic.
 
M

Max

Some observations:
1. Do you mean: =SUM(G3:I3) instead of =SUM(G3-I3) ?
2. Press F9 - does it compute properly ? If so, then the calc mode was on
manual. To check / change calc mode: Click Tools > Options > Calculation tab
3. Is the formula cell formatted as text ? Check / change to either General
or Number via: Click Format > Cells > Number tab, then re-enter the formula.
 
E

Earl Kiosterud

Lollycat,

=SUM(G3-I3) is equivalent to =G3-I3. You should get the difference, G3
minus I3.
 
Top