» Summing How Many Points Scored by a Specified Team in Specified Games
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Listed in columns A:C are the point totals scored by teams A and B in the first four games of the season.
We want to calculate the total number of points scored by Team B in the first two games.
Solution:
Use the SUM function as shown in the following Array formula:
{=SUM((A2:A9="B")*(B2:B9<=2)*C2:C9)}
Book Store:
Recommended Books:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The One Page Business Plan: Start With a Vision, Build a Company!
- The Ernst & Young Business Plan Guide
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Special Edition Using Microsoft Access 2002
- Excel 2002 For Dummies®
No comments have been submitted.

