SUM Formula

LHurley

I have written a formula to convert a word into a numeric value. When I try to add all the columns of the converted number to get the sum, it does not recognize the cell as a number so it returns a Zero. I feel like I need to convert the formula's conversion into a number instead of Text? Please help!

SSFeatures

Hi @LHurley, can you post the formula that you're using? Can you also post a screenshot as well, just so that I make sure that I understand the sheet as well

Thank you!

LHurley

Here is the formula….=IF([Score #10]@row = "POOR (0 Look fors)", "1", IF([Score #10]@row = "FAIR (Min Look fors)", "2", IF([Score #10]@row = "GOOD (Many Look fors)", "3", IF([Score #10]@row = "EXCELLENT (Most Look fors)", "4"))))

The scores for "Total Score by Interviewer" and "Score Summary" were manually calculated. I'd like a formula that will sum all of the "Numerical Score" Columns for each person. The above formula calculates the "Numerical Score" column