Thread
:
IF formula & Percentage
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
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
Reply With Quote