"Ron Rosenfeld" skrev i en meddelelse
...


If you do not want to use an adjacent column and lookup table, you could
use
the following formula:

=SUM(COUNTIF(A:A,"excellent")*5,COUNTIF(A:A,"Good" )*4,
COUNTIF(A:A,"Average")*3,COUNTIF(A:A,"Fair")*2,
COUNTIF(A:A,"Poor"))/COUNTA(A:A)

You may want to adjust the reference to column A.


Hi Ron

Or shorter

=SUM(COUNTIF(A:A,{"Excellent","Good","Average","Fa ir","Poor"})*{5,4,3,2,1})/COUNTA(A:A)

Maybe even

=SUM(COUNTIF(A:A,{"Excellent","Good","Average","Fa ir","Poor"})*{1,2,3,4,5})/COUNTA(A:A)

:-)

LeoH