Formula for nonnumeric percentage

  • Thread starter Thread starter Taleen
  • Start date Start date
T

Taleen

I have a spreadsheet that contains employee information.
I have 1 column that states the sex (M or F). Now I want
to know using a formula, what is the percentage of female
employees.

Thanks,
Taleen
 
Thanks!! It worked perfectly.

Taleen
-----Original Message-----
If E1 to E9 contained the M/F's
=COUNTIF(E1:E9,"F")/COUNTA(E1:E9)

Format the cell as percentage

Dan E




.
Click to expand...
 
Taleen

=COUNTIF(A1:A20,"F")/COUNTA(A1:A20)

Format as Percent.

Gord Dibben Excel MVP XL2002
 
Back
Top