View Single Post
  #6   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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