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

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

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

2. ## Alternate formula

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

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

#### 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