Keeping score

[The Fool on the Hill]

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?
------------------------------------

 

[Max]

With the teams listed in E1 down,

In F1:
=SUMIF(C:C,E1,A:A)

In G1:
=SUMIF(D,E1,B:B)

Select F1:G1, fill down

 

[The Fool on the Hill]

Thanx !

It worked !

With the teams listed in E1 down,

In F1:
=SUMIF(C:C,E1,A:A)

In G1:
=SUMIF(D,E1,B:B)

Select F1:G1, fill down

 

[Max]

You're welcome !
Thanks for calling back ..