» 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
