1. ## 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. ## 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. ## Re: Sum Product (2003)

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

#### Posting Permissions

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