this doesnt work.....returns an error

"T. Valko" wrote:

I used a IF formula to assign scores of 1-4
Using SUM does not work

In your IF formula remove the quotes from around any numbers. For example:

WRONG:

=IF(A1="A","1","0")

RIGHT:

=IF(A1="A",1,0)

--
Biff
Microsoft Excel MVP


"shadesoflife" wrote in message
...
Would anyone be able to advise me how to go about summing the
values/outputs
that result from the use of a IF formula?

Background - I used a IF formula to assign scores of 1-4 for the
categories
low, moderate, significant and high. I now need to sum these scores. Using
SUM does not work nor does SUMIF...

help pls