Summing Values/Outputs of IF formulae
So, as previously instructed, drop the quotes around the numbers:
=IF(D58="",0,IF(D58="LOW",1,IF(D59="MODERATE",2,IF (D58="SIGNIFICANT",3,4))))
shadesoflife wrote:
=IF(D58="","0",IF(D58="LOW","1",IF(D59="MODERATE", "2",IF(D58="SIGNIFICANT","3","4"))))
" wrote:
Post a copy of your IF formula. It seems like you should be able to
SUM the results without any problem; unless you are assigning your
scores as "1", "2", etc.
Ken
On May 13, 4:24 pm, shadesoflife
wrote:
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
|