» Summing How Many Points Scored by a Specified Team in Specified Games

CATEGORY - Excel Formula and Function 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 in the following Array formula:
{=SUM((A2:A9=""B"")*(B2:B9<=2)*C2:C9)}

Example:

Team____Game #___Points
A_______1________15
B_______1________10
A_______2________20
B_______2________13
A_______3________9
B_______3________14
A_______4________15
B_______4________13

Result 23
Screenshot // Summing How Many Points Scored by a Specified Team in Specified Games