+ Reply to Thread
Results 1 to 2 of 2

Working out archery division using 2 columns. Age in one, *** in the other

  1. #1
    Registered User
    Join Date
    02-23-2015
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    1

    Working out archery division using 2 columns. Age in one, *** in the other

    Hi guys,
    I am sure its simple for you but as someone thats been thrown in the deep end I cant for the life of me get this to work.

    I have 3 divisions that people are in. Adults, Juniors and cubs. Grabbing that data and using it was easy enough using just an age column. I am now trying to grab the data and split it up so I can see the number of Female members vs male members in each division.

    I have managed to do the adults and cubs divisions as follows:
    Cubs:
    =COUNTIFS( M2:M99, "f", L2:L99, "<13" )
    =COUNTIFS( M2:M99, "m", L2:L99, "<13" )
    Adults:
    =COUNTIFS( M2:M99, "f", L2:L99, ">=17" )
    =COUNTIFS( M2:M99, "m", L2:L99, ">=17" )

    The issue I am having is juniors!
    The data I need to get is the number of Junior girls and boys.
    I grabbed the overall data with:
    =SUMPRODUCT(--(L2:L98<17),--(L2:L98>12))
    My question is how do I make a formula that has the following
    Less than 17, Greater than 12 and male
    Less than 17, Greater than 12 and female

    It has me completely stumped due to the fact that I have no idea how.

    Thanks in advance for helping out someone that only started learning excel a week ago.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Working out archery division using 2 columns. Age in one, *** in the other

    =COUNTIFS(gender, "m", age, ">12", age, "<17")
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Division of two columns across multiple rows
    By WiscoEm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2013, 03:44 PM
  2. Replies: 1
    Last Post: 06-03-2013, 06:23 PM
  3. Replies: 1
    Last Post: 06-03-2013, 06:14 PM
  4. [SOLVED] archery score allowances
    By zardof in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2012, 05:18 AM
  5. [SOLVED] Archery Classification Problem
    By zardof in forum Excel General
    Replies: 20
    Last Post: 08-02-2012, 04:14 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1