Hi,

Just remove all quotation marks (") from your formulae. Currently they
return text (".45") instead of numeric values (.45).

Regards,
KL


"thomasjefferson" wrote in
message ...
I'm trying to use a spreadsheet as a database for wedding invitations. In
column F, I have assigned each row (each individual guest) a value of 1,
2,
3, or 4 according to whether I judge they are definitely coming, probably,
possibly, or doubtful. In the next column (column G), I have successfully
managed to use the IF function to enter in each cell as a decimal number
between 0 and 1 the probability that that guest will come. Here is the
formula for the first cell in that column:
=IF(F2=1,".95",IF(F2=2,".75",IF(F2=3,".45",IF(F2=4 ,".2"))))

So far so good.

Here's the problem. When I try to sum column G, with the formula
=SUM(G2:G294), Excel insists that the answer is 0, even though I'm looking
at
a column of 293 cells, all of which have one of four results in them
(i.e.,
.95, .75, .45, or .2). When I sum column G by hand, I get a result of
222.6.

Please help me.