Find the average of fields containing text

V

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
 
P

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
.
Click to expand...
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
[email protected]
 
Top