+ 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,963
    Thank Post
    64
    Thanked 374 Times in 284 Posts
    Rep Power
    159
    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,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    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,158
    Thank Post
    78
    Thanked 253 Times in 227 Posts
    Rep Power
    77
    Cant you just use countif

    eg =countif(a1:a100, M)

  7. #7

    Join Date
    Apr 2008
    Location
    Keighley, West Yorks
    Posts
    326
    Thank Post
    52
    Thanked 49 Times in 43 Posts
    Rep Power
    21
    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
  •