On Sat, 21 May 2005 09:17:58 +0200, "Leo Heuser"
wrote:
Or shorter
=SUM(COUNTIF(A:A,{"Excellent","Good","Average","F air","Poor"})*{5,4,3,2,1})/COUNTA(A:A)
Maybe even
=SUM(COUNTIF(A:A,{"Excellent","Good","Average","F air","Poor"})*{1,2,3,4,5})/COUNTA(A:A)
I like that. And your second answer even gives the result expected by the
OP!!!!
--ron
|