Office Software Thread, How to count number of Male & Female in a column on a spreadsheet in Technical; Does anyone have any idea of how to count the number of F's and M's in a single column then ...
1. ## 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 !

2. 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

3. 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.

4. 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

Sort M and F.xls

Above is much easier. I missed that one

5. 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.

6. Cant you just use countif

eg =countif(a1:a100, M)

7. 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

SHARE: