Counting The Number of Players According To Their Score In A Particular Quarter

[ExcelTip]

Problem:

Finding the number of players (column A) who scored over 3 points (column C) in the first quarter (column B).

Solution:

Use the SUMPRODUCT function as follows:
=SUMPRODUCT((B2:B17=F2)*(C2:C17>F3))

Example:
Player___Quarter____Score
1________1__________5
_________2__________2
_________3__________6
_________4__________3
2________1__________2
_________2__________1
_________3__________3
_________4__________2
3________1__________4
_________2__________5
_________3__________3
_________4__________2
4________1__________1
_________2__________4
_________3__________3
_________4__________3


Result___2

[Dennis Taylor]

Or try this array formula:
{=SUM(IF(C2:C17>3,IF(B2:B17=1,1)))}