I am trying to write a program to collect scores of basketbal games. Here is
what I have. Column A is the team and where they played (varies). Column B is
the score. I would like to look-up the team (ignoring where they played) and
add all the score together. In The Below example, I need to add row 1 and 3
but I am having trouble using the sumproduct formula ignoring the where thay
played. Help!!

A B
1 TEAM A (@ XXX) SCORE
2 TEAM B (@ XXX) SCORE
3 TEAM A (@ YYY) SCORE
4 TEAM C (@ ZZZ) SCORE
5 TEAM B (@ VVV) SCORE