+ Post New Thread
Results 1 to 5 of 5
How do you do....it? Thread, Count the number of Girls and Boys in 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

    Count the number of Girls and Boys in 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


    Join Date
    May 2009
    Posts
    3,395
    Thank Post
    301
    Thanked 917 Times in 684 Posts
    Rep Power
    346
    You want to look at the countif function. Typically you would have a cell set =countif(<range>,<criteria>). So if you have a column B with rows 1-10 containing gender values of either "M" or "F", you might have =countif("B1:B10","M"), which will give you the number of cells containing "M".

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    As I posted in your other identical thread (why do that? It's SPAM!):

    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.

  4. Thanks to LosOjos from:

    EaglesNerd (23rd March 2011)

  5. #4
    El_Nombre's Avatar
    Join Date
    Sep 2008
    Posts
    288
    Thank Post
    63
    Thanked 25 Times in 19 Posts
    Rep Power
    18
    If you've got just "M" or "F" or "Boy" or "Girl" in the column, select the heading and then go Data > Filter > auto filter. Use the dropdown box that appears to select all the, say, "Girl" entries. The number of those particular entries will be displayed in the very bottom left of your screen, and now only those entries show (to clear that, select the dropdown arrow again which is now blue.) Fill the first cell in the column then drag to fill for the rest of the girls, repeat with boys, should all be good.

    Quick and dirty way to do it if I'm actually getting what you needed.
    Last edited by El_Nombre; 22nd March 2011 at 01:28 PM.

  6. #5

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    5,375
    Thank Post
    958
    Thanked 1,630 Times in 1,103 Posts
    Blog Entries
    47
    Rep Power
    711
    Could also use lists to do it... select the whole range, press Ctrl+L to turn it into a list, toggle total row on, set up a count in any column and then filter to just show the boys/girls. Quick n dirty if you just want to know the number, not so good if you're setting up a permanent cell (for which use countif, as others have said. that might just be easier anyway)



SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] How to count number of Male & Female in a column on a spreadsheet
    By EaglesNerd in forum Office Software
    Replies: 6
    Last Post: 18th March 2011, 01:51 PM
  2. Number of Computers, versus Number of Images
    By AnnDroyd in forum Network and Classroom Management
    Replies: 23
    Last Post: 4th October 2010, 07:01 PM
  3. Replies: 1
    Last Post: 15th October 2009, 12:52 PM
  4. Boys from the Dwarf!!!!!
    By flyinghaggis in forum General Chat
    Replies: 17
    Last Post: 27th January 2009, 11:16 PM
  5. Well hello boys
    By beeswax in forum General Chat
    Replies: 0
    Last Post: 29th June 2008, 04:37 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
  •