» 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:
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Windows XP Registry Guide
- Investing for Dummies, Third Edition
- Analysis of Financial Statements
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Investing in Real Estate, Fourth Edition
No comments have been submitted.


