[ms office - 2003] How to count number of Male & Female in a column on a spreadsheet

[EaglesNerd]

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 !

[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

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

Edited March 18, 2011 by Andrew_C
Late edit

[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

 

Sort M and F.xls

 

Above is much easier. I missed that one

Edited March 18, 2011 by cromertech
must do better :-)

[LosOjos]

COUNTIF will do this, e.g.

 

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

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

 

 

you'll need to change the range accordingly.

[jamesreedersmith]

Cant you just use countif

 

eg =countif(a1:a100, M)

[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