Transferring team scores into a league table

[JonSt]

Hi, I hope someone can help with my question.

I have a list of team fixtures and scores, that will go on for a whole season. What I want to do is take the points won by each team in each game and count them up in the table to the right on the spreadsheet. I can then add up each 3, and 1 pointers to show who ends up where in a proper league table.

Can anyone help me and show me if I can write a formula that will look down the Home team list (column B), find a particular team and then count the number of 3's, 1's and 0's in column E into the Home table on the right (Columns I, J & K), and then the same for the away team into the Away table?

I've manually inputted the figures for TEAM 1 & 2 where the numbers in red in the list on the left are what I want counted into the green numbers on the right.

I hope that makes sense and someone can help.

Thanks,

Jon

Using Excel 2008 (Mac) saved as 97-2004 xls