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

Ravisankar Sivasubramaniam wrote:

> 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