# How to count number of Male & Female in a column on a spreadsheet

• 18th March 2011, 12:55 PM
EaglesNerd
How to count number of Male & Female in a column on a spreadsheet
Does anyone have any idea of how to count the number of F's and M's in a single column then have a Girl and Boy key that relates to that column????? PLEASE HELP !
• 18th March 2011, 01:13 PM
cromertech
You can do this is Access with a duplicates query but I'm guessing you want Excel to do it and I'm not entirely sure if its possible (at least I've not been able to do it in the ten minutes I've had so far) I'll keep trying and let you know hopefully without making the 2010 spreadsheet incompatible with 2003
• 18th March 2011, 01:21 PM
Andrew_C
You need to use DCOUNT in Excel. One field to count F, one to count F.

Or =COUNTIF(B85:AA85,"=F") counts the "F"s in row 85, between columns B and AA.
• 18th March 2011, 01:23 PM
cromertech
It can sort of be done. Take a look at the file below. Uses an IF statement to sort boy or girl and SUM for the key

Attachment 9750

Above is much easier. I missed that one :doh:
• 18th March 2011, 01:23 PM
LosOjos
COUNTIF will do this, e.g.

Code:

```for Male:     =COUNTIF(A1:A100,"M") for Female:     =COUNTIF(A1:A100,"F")```

you'll need to change the range accordingly.
• 18th March 2011, 01:24 PM
jamesreedersmith
Cant you just use countif

eg =countif(a1:a100, M)
• 18th March 2011, 01:51 PM
howartp
As people have said, COUNTIF() will do the counting.

However could the OP explain the latter part of the query - having a Girl and Boy key that relates to the column?

Peter