Transferring team scores into a league table

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

Had some time on my hands. I thought it would be easier to just fix your sheet. All you have to do now enter the scores. Everything else is done for you.

Sorry there was en error that I fixed so I re uploaded

I never new that sumif worked that way. Sure makes the sheet alot neater.

the =match(k4...ect was used to find the team in the first column and note if row position. but the verision done by zbor is alot easier let me make some changes and up load it for you.

Here is the update. If you explain what you would like to add to the sheet in a little more detail. I may be able to assist.

Thanks very much, I'll have a look at that and see what's what