» Summing How Many Points Scored by a Specified Team in Specified Games
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: 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:
- Advanced modelling in finance using Excel and VBA
- Accounting Principles, with CD, 6th Edition
- Guide to Financial Reporting and Analysis
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- The 11 Immutable Laws of Internet Branding
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
