Average of Data->Validation->List

  • Thread starter Thread starter Ravisankar Sivasubramaniam
  • Start date Start date
R

Ravisankar Sivasubramaniam

Hello,

I have defined a Excel 'list' and have used its values as valid inputs (for
certain range of cells). If this list contains 5 values (representing a
5-point rating scale) and if I want to find the average (first value of the
list corresponding to '1' rating and the lst value corresponding to '5'
rating), what should I do?

Thanks,
Ravi
 
If the values in your pick list are numbers, then you can just use the
AVERAGE function to average the cells.

If that were the case, I presume you would have realized the answer
yourself, so I will guess that the pick list is of text descriptions.
In that cause, use something like

=(COUNTIF(rng,text1) +2*COUNTIF(rng,text2) +3*COUNTIF(rng,text3)
+4*COUNTIF(rng,text4) +5*COUNTIF(rng,text5)) / COUNTA(rng)

Jerry
 
Back
Top