Tip Printed from ExcelTip.com

---

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 shown in the following formula:
=SUMPRODUCT((B2:B17=F2)*(C2:C17>F3))