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