Find the average of fields containing text

[Valerie]

I am trying to find the average of column containing only
text fields(ex. low, medium, high). I have temporarily
assigned a numerical value to the text in a separate
column. Is there a way to return the average of this
information without changing my data? Thanks for your
help.

VLaBelle

 

[Peter Atherton]

-----Original Message-----
I am trying to find the average of column containing only
text fields(ex. low, medium, high). I have temporarily
assigned a numerical value to the text in a separate
column. Is there a way to return the average of this
information without changing my data? Thanks for your
help.

VLaBelle
.

Valerie

I think not, but you could find the proportions using this
formula =COUNTIF($F$13:$F$20,"high")/COUNTA($F$13:$F$20)

Copy the formula and Change the criteria to "Med" and "Low"

Cells could be formated as percentages if you prefer.

Regards
Peter Atherton
(e-mail address removed)