I need to keep them in the order of the games played. So they are shown with
the "@" symbol. Any suggestions?


"CLR" wrote:

Personally, I would use Data TextToColumns to separate the teams out into
their own columns....then a regular SUMIF would work......and you could use
another SUMIF to figure their "away" points as well.........

Vaya con Dios,
Chuck, CABGx3



"Mark" wrote:

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 scores together. In The Below example, I need to add row 1 and 3
but I am having trouble using the sumproduct formula ignoring where they is
giving me problems--- Please Help!! How can I write this ignoring the (@ XXX).

A B
1 Knicks (@ Boston) 89
2 Boston (@ LA) 91
3 Knicks (@ Toronto) 105
4 Miami (@ LA) 112
5 Boston (@ Spurs) 107