Counting letters for male/female

  • Thread starter Thread starter Aladin Akyurek
  • Start date Start date
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?
 
=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)
 
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?
 
Are you trying to count just Y and N in a range or there is something else
to take into account?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data only if adjacent to cell labeled "male"/"female" 1
Count? 4
Count Text in Columns 1
counting two ranges for one criteria 1
countif OR function 5
count across 3 columns 8
If, then 1
COUNTIF Question 12

Back
Top