Find the average of fields containing text

  • Thread starter Thread starter Valerie
  • Start date Start date
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
 
-----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
(e-mail address removed)
 
Back
Top