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 ...
18th March 2011, 11:55 AM #1
- Rep Power
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, 12:13 PM #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
18th March 2011, 12:21 PM #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.
Last edited by Andrew_C; 18th March 2011 at 12:28 PM.
Reason: Late edit
18th March 2011, 12:23 PM #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
Last edited by cromertech; 18th March 2011 at 12:24 PM.
Reason: must do better :-)
18th March 2011, 12:23 PM #5
COUNTIF will do this, e.g.
you'll need to change the range accordingly.
18th March 2011, 12:24 PM #6
Cant you just use countif
eg =countif(a1:a100, M)
18th March 2011, 12:51 PM #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?
By mbyrew in forum MIS Systems
Last Post: 15th October 2009, 11:52 AM
By teddybear in forum General Chat
Last Post: 1st September 2009, 10:14 PM
By link470 in forum Hardware
Last Post: 22nd January 2009, 09:42 AM
By Pottsey in forum General Chat
Last Post: 14th December 2007, 02:29 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)