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


Replace @mailinator.com with @tiscali.co.uk


"adam.carson" wrote in message
...
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?