Counting letters for male/female

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?
 
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)
 
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?
 
A

Aladin Akyurek

Are you trying to count just Y and N in a range or there is something else
to take into account?
 

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
pull out certain data 1
If, then 1
Count Text in Columns 1
At least two males 1
General Excel question 24
count across 3 columns 8
counting two ranges for one criteria 1

Top