Summing Values/Outputs of IF formulae

S

shadesoflife

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
 
K

krcowen

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
 
K

krcowen

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
 
T

T. Valko

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

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)
 
T

T. Valko

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

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)
 
S

shadesoflife

=IF(D58="","0",IF(D58="LOW","1",IF(D59="MODERATE","2",IF(D58="SIGNIFICANT","3","4"))))
 
S

shadesoflife

=IF(D58="","0",IF(D58="LOW","1",IF(D59="MODERATE","2",IF(D58="SIGNIFICANT","3","4"))))
 
S

shadesoflife

this doesnt work.....returns an error

T. Valko said:
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)
Click to expand...
 
S

shadesoflife

this doesnt work.....returns an error

T. Valko said:
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)
Click to expand...
 
T

T. Valko

=IF(D58="","0",IF(D58="LOW","1",IF(D59="MODERATE","2",IF(D58="SIGNIFICANT","3","4"))))

Remove the quotes from around the numbers:

=IF(D58="",0,IF(D58="LOW",1,IF(D59="MODERATE",2,IF(D58="SIGNIFICANT",3,4))))

When you quote numbers they get evaluated as TEXT. The SUM function ignores
text.
 
T

T. Valko

=IF(D58="","0",IF(D58="LOW","1",IF(D59="MODERATE","2",IF(D58="SIGNIFICANT","3","4"))))

Remove the quotes from around the numbers:

=IF(D58="",0,IF(D58="LOW",1,IF(D59="MODERATE",2,IF(D58="SIGNIFICANT",3,4))))

When you quote numbers they get evaluated as TEXT. The SUM function ignores
text.
 
G

Glenn

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))))
 
G

Glenn

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))))
 
S

shadesoflife

Thank you

Glenn said:
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))))
Click to expand...
 
S

shadesoflife

Thank you

Glenn said:
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))))
Click to expand...
 
S

shadesoflife

Thanks!

T. Valko said:
Remove the quotes from around the numbers:

=IF(D58="",0,IF(D58="LOW",1,IF(D59="MODERATE",2,IF(D58="SIGNIFICANT",3,4))))

When you quote numbers they get evaluated as TEXT. The SUM function ignores
text.
Click to expand...
 
S

shadesoflife

Thanks!

T. Valko said:
Remove the quotes from around the numbers:

=IF(D58="",0,IF(D58="LOW",1,IF(D59="MODERATE",2,IF(D58="SIGNIFICANT",3,4))))

When you quote numbers they get evaluated as TEXT. The SUM function ignores
text.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing up values 5
Summing across multiple worksheets in excel 2007 3
using a result of a formula to generate text in Excel 2003 2
Problem with LARGE function 3
sumif and complex sum_range formulae 2
testing range of cells for part of cell content 5
Is it possible to SUM based on value of another column? 3
Summing Sheets - SUMIF ? 8

Top