+ Post New Thread
Results 1 to 7 of 7
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. #1

    Join Date
    Sep 2010
    Location
    United Kingdom
    Posts
    22
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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. #2
    cromertech's Avatar
    Join Date
    Dec 2007
    Location
    Cromer by the coast
    Posts
    731
    Thank Post
    177
    Thanked 109 Times in 97 Posts
    Rep Power
    54
    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. #3

    Andrew_C's Avatar
    Join Date
    Sep 2005
    Location
    Winchester
    Posts
    2,975
    Thank Post
    64
    Thanked 378 Times in 288 Posts
    Rep Power
    160
    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

  4. #4
    cromertech's Avatar
    Join Date
    Dec 2007
    Location
    Cromer by the coast
    Posts
    731
    Thank Post
    177
    Thanked 109 Times in 97 Posts
    Rep Power
    54

    Lightbulb

    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 :-)

  5. #5

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,487
    Thank Post
    1,445
    Thanked 1,182 Times in 809 Posts
    Rep Power
    709
    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. #6
    jamesreedersmith's Avatar
    Join Date
    Sep 2009
    Location
    Ruskington
    Posts
    1,166
    Thank Post
    78
    Thanked 258 Times in 230 Posts
    Rep Power
    78
    Cant you just use countif

    eg =countif(a1:a100, M)

  7. #7

    Join Date
    Apr 2008
    Location
    Keighley, West Yorks
    Posts
    339
    Thank Post
    52
    Thanked 51 Times in 45 Posts
    Rep Power
    22
    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:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 15th October 2009, 11:52 AM
  2. Are you male or female?
    By teddybear in forum General Chat
    Replies: 3
    Last Post: 1st September 2009, 10:14 PM
  3. Replies: 2
    Last Post: 22nd January 2009, 09:42 AM
  4. Replies: 42
    Last Post: 14th December 2007, 02:29 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •