IF formula & Percentage
 

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

IF formula & Percentage
 

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

HTH
--
AP

"Drummy" a écrit dans
le message de news: ...

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