Dear Excel(lent) users,

I am making a very simple score sheet for a korfball competition.

In a number of columns I have different sets of information. I am now
focussing on the following:

Column A Column B Column C Column D
3 2 Team 1 Team 2
2 1 Team 2 Team 3
1 1 Team 3 Team 1
2 2 Team 2 Team 1
3 1 Team 1 Team 3

Now I want to know the score of the teams (how many goals they scored).

E.G. Team one scored 6 goals and received 3

So I am making a new set of columns with the following info
Scored goals Goals Against
Column E Column F Column G
Team 1 6 3
Team 2 4 2
Team 3 1 2

Can someone help me please?
------------------------------------