Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2005
    Location
    Br. Columbia, Canada
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sum Product (2003)

    I've been handed a list of stats broken down by Gender, Age, Grade and Rank (0 to 5). I was able to count the number of people of each rank using the COUNTIF function. From reading other posts I see that COUNTIF does not work with multiple criteria. I need to count the number of Females (F) of a certain age (0 to 11). I used the following formula:

    =SUMPRODUCT(($A$2:$A$1084="f")*($B$2:$B$1084 <=11))

    I now need to count the number of Females between the ages of 11 and 20. Is it possible to enter in a range of ages or do i need to count the number of females under the age of 20 and subtract from that the number of females under the age of 11 in order to get the correct result?

    Thanks,

    Kara

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sum Product (2003)

    You can add other conditions using multiplication:

    =SUMPRODUCT(($A$2:$A$1084="f")*($B$2:$B$1084 >11)*($B$2:$B$1084 <=20))

    Adjust the age limits as needed.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum Product (2003)

    <code>
    =SUMPRODUCT(($A$2:$A$1084="f")*($B$2:$B$1084 >11)*($B$2:$B$1084 <20))
    </code>
    Legare Coleman

Posting Permissions

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