On Sat, 21 May 2005 09:17:58 +0200, "Leo Heuser" <leo.heuser@NOSPAMadslhome.dk>
wrote:

>
>Or shorter
>
>=SUM(COUNTIF(A:A,{"Excellent","Good","Average","Fair","Poor"})*{5,4,3,2,1})/COUNTA(A:A)
>
>Maybe even
>
>=SUM(COUNTIF(A:A,{"Excellent","Good","Average","Fair","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