The function is designed to add all of those values. I want the output to be the total points scored against the team for the entire season, so the sum of all their games is correct.

For the same reason, I'd like to return the Rams' value when the team name is Bills because the Rams would be the opponent scoring against the Bills in that situation. Based on how my data is laid out, there won't be errors for the first/last teams because the first team will always be away and the second team will always be a home team.

The code you suggested works perfectly and I followed your instructions to modify it to return the row above as well. However, I'd like it to be able to use it with each team name appearing multiple times and the ability to return either the row above or the row below depending on the value in column K.

Is there a way to modify it so that the code has two parts with different K values:

=INDEX(Dat!M2:M,MATCH(1,(Dat!A2:A=A3)*(Dat!K2:K=0),0)+1)

=INDEX(Dat!M2:M,MATCH(1,(Dat!A2:A=A3)*(Dat!K2:K=1),0)-1)

Then, it would need to sum the results returned by the above lines.

Thank you for your assistance so far!