» Counting the Number of Players According to Their Score in a Particular Quarter
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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 shown in the following formula:
=SUMPRODUCT((B2:B17=F2)*(C2:C17>F3))
Book Store:
{=SUM(IF(C2:C17>3,IF(B2:B17=1,1)))}