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 ...
18th March 2011, 12:55 PM #1
- Rep Power
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 !
18th March 2011, 12:58 PM #2
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".
18th March 2011, 01:29 PM #3
As I posted in your other identical thread (why do that? It's SPAM!):
COUNTIF will do this, e.g.
you'll need to change the range accordingly.
Thanks to LosOjos from:
EaglesNerd (23rd March 2011)
22nd March 2011, 01:22 PM #4
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.
22nd March 2011, 01:58 PM #5
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)
By EaglesNerd in forum Office Software
Last Post: 18th March 2011, 01:51 PM
By AnnDroyd in forum Network and Classroom Management
Last Post: 4th October 2010, 07:01 PM
By mbyrew in forum MIS Systems
Last Post: 15th October 2009, 12:52 PM
By flyinghaggis in forum General Chat
Last Post: 27th January 2009, 11:16 PM
By beeswax in forum General Chat
Last Post: 29th June 2008, 04:37 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)