» 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:
Recommended Books:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Financial Statement Analysis with S&P insert card
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Excel Charts
{=SUM(IF(C2:C17>3,IF(B2:B17=1,1)))}