Well....you tell me.
I treated the data as if it was rankings: High:1, Med:2, Low:3 and
calculated the average.

The average of 5 High, 2 Med, and 2 Low
is the average of {1,1,1,1,1,2,2,3,3}

Which is 1.6666....

which rounds to 2.

Unless you want to have:
High, Med-High, Med, Med-Low, Low

Am I on the right track here?

***********
Regards,
Ron


"Weave" wrote:

Ron,

Sorry for the guessing game. Good guessing though. I tried it, but I'm
still a little skeptical. The drop-down lists of high, medium, low are
located in E10, E12, E15, E18, E22, E25, E28, E32, and E34. If 5 of those
are high, 2 are medium, and 2 are low is "medium" the correct "average" and
why? Thanks alot Ron.

"Ron Coderre" wrote:

Guessing here....

With High's, Medium's, and Low's dispersed in cells A1:A10,
Is this what you're looking for?
=CHOOSE(ROUND(AVERAGE(MATCH(A1:A10,{"High","Medium ","Low"},0)),0),"High","Medium","Low")

Note: Confirm that array formula by holding down [Ctrl] and [Shift] when you
press [Enter].

Does that help?

***********
Regards,
Ron


"Weave" wrote:

I'm trying to get an average on high, medium, and low values whereby the
values are displayed in text. There is only one text value listed per cell
for about 9 rows. I need the average results displayed in text. (i.e.
A1=high, A2=medium, A3=low, etc.). In a separate cell I need the average of
highs-lows displayed in the words, "high", "medium", or "low" (w/out the
quotations).