» Counting the Number of Players According to Their Score in a Particular Quarter
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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))
Book Store:
Recommended Books:
- Accounting and Financial Fundamentals for Nonfinancial Executives
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Special Edition Using Microsoft Excel 2002
- Windows XP All-in-One Desk Reference For Dummies
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
