Help with this formula.

[adam.carson]

I am working with a bunch of qualitative data, such as Poor, Fair, Good, and
Exc. I am trying to give a value to each response and total up each person's
responses with a sum that I am hoping to draw conclusions for. Can someone
help me as to how to do this please?

 

[Sandy Mann]

Try something like:

=SUM(COUNTIF(A1:A21,"Poor")*1,COUNTIF(A1:A21,"Fair")*4,COUNTIF(A1:A21,"good")*7,COUNTIF(A1:A21,"Exc")*10)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk