Using IF function to create scores

[dwherron]

Hi, I am using the IF function to create a score.

E.G =IF(F25= "C","5", "0") This creates a score of 5. 

I have put the various formulas and scores into the appropriate cells, however when i use the sum function to add up the scores i get 0.

How can i add the scores?

[#2]

@dwherron 

Values enclosed in quotes, such as "5", are text. Since you want to sum the values, omit the quotes:

=IF(F25="C", 5, 0)