Formula for nonnumeric percentage

[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

 

[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




.

 

[Gord Dibben]

Taleen

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

Format as Percent.

Gord Dibben Excel MVP XL2002