IF formula & Percentage

[Drummy]

OK, say whats below is E3:E17 in a column on a worksheet and I wanted to put formulas in seperate cells stating the percentage of m's and f's in the column, what would that formula be??

f
m
m
m
m
m
m
f
f
f
f
f
m
f
m

[Ardus Petus]

=COUNTIF(A:A,"f")/COUNTA(A:A)
=COUNTIF(A:A,"m")/COUNTA(A:A)

HTH
--
AP

"Drummy" <[email protected]> a écrit dans
le message de news: [email protected]...
>
> OK, say whats below is E3:E17 in a column on a worksheet and I wanted to
> put formulas in seperate cells stating the percentage of m's and f's in
> the column, what would that formula be??
>
> f
> m
> m
> m
> m
> m
> m
> f
> f
> f
> f
> f
> m
> f
> m
>
>
> --
> Drummy
> ------------------------------------------------------------------------
> Drummy's Profile:
> http://www.excelforum.com/member.php...o&userid=34780
> View this thread: http://www.excelforum.com/showthread...hreadid=548451
>