A
Aladin Akyurek
=COUNTIF(Range,"M")
Substitute F for M for the female count.
Substitute F for M for the female count.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RDL17
Hi,
I have a colummn that has either the letter "F" of "M" in
it for female of male, for hundreds of entries. How can I
figure out how many females or males there are?
I have a colummn that has either the letter "F" of "M" in
it for female of male, for hundreds of entries. How can I
figure out how many females or males there are?
F
Frank Kabel
Hi
use COUNTIF. e.g.
=COUNTIF(A:A,"M")
use COUNTIF. e.g.
=COUNTIF(A:A,"M")
P
Peo Sjoblom
=COUNTIF(Range,"M")
change M to F for femmes
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
change M to F for femmes
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
G
Guest
Thanks, that works great. I have to do the same thing
with "Y" and "N", but there ar esome blank cells were some
one didnt amswer the question. When I use the formula you
gave me, the answer is zero. Can you help?
with "Y" and "N", but there ar esome blank cells were some
one didnt amswer the question. When I use the formula you
gave me, the answer is zero. Can you help?
A
Aladin Akyurek
Are you trying to count just Y and N in a range or there is something else
to take into account?
to take into account?