Browse
Category
DiscussionsOff Topic

Excel football table

Closed
rex2630

Hi, guys.Im here again and want help with excel, right.
I must create football table, thats easy.But how can i create points with fuction if, if i need to count 3 matches.Won only for each team, if u understand me.
Is anyone here, who can help me with it, please?
Thanks :)

tým=team
skóre=score
body=points
pořadí=ranking

Now it looks like this:

View attached image.
8 years ago*

Comment has been collapsed.

16 Comments
aforce273

I don't quite understand what you're trying to accomplish. Do you want to count the best match of each team? And in your current table, is that Team 1 plays against Team 1, etc?

8 years ago
Permalink

Comment has been collapsed.
rex2630

I want to count won matches for each team :)

8 years ago
Permalink

Comment has been collapsed.
rex2630

Do u know how to do that?

8 years ago
Permalink

Comment has been collapsed.
aforce273

Maybe if I understood your table better. I don't understand the cells where the same team meets.

8 years ago
Permalink

Comment has been collapsed.
rex2630

Cause on top are teams what played and on left score/points/ranking of each team

8 years ago
Permalink

Comment has been collapsed.
aforce273

So the left side team labels only apply to the right side score, points, and rank columns? Sounds like they should be separate tables but if it's only for personal use then only you need to understand your system. As for the columns for each team: is each row their match points followed by the opposing team's match points?

8 years ago
Permalink

Comment has been collapsed.
rex2630

Yeah, exactly

8 years ago
Permalink

Comment has been collapsed.
aforce273

If body/points is the sum of scores from only won games and assuming your table starts in cell A1, then you'll want to use the following functions:

Team 1 (I2):
=SUM(IF(B2>C2,B2,0),IF(B3>C3,B3,0),IF(B4>C4,B4,0))
Team 2 (I3):
=SUM(IF(D2>E2,D2,0),IF(D3>E3,D3,0),IF(D4>E4,D4,0))
Team 3 (I4):
=SUM(IF(F2>G2,F2,0),IF(F3>G3,F3,0),IF(F4>G4,F4,0))

8 years ago
Permalink

Comment has been collapsed.
rex2630

What?I dont understand that

8 years ago
Permalink

Comment has been collapsed.
aforce273

First, do you understand the alphanumeric cell designation and does your table start at A1?
For each team, there are 3 IF statements corresponding to each match they played. The IF function has 3 parameters. The first is the condition: is the team's score greater than their opponent. The second parameter is what the if statement returns if that condition is true, specifically the team's score. The last parameter is what is returned if it is false: a zero so the teams score is not counted since they lost. Then we SUM the 3 IF statements.

8 years ago
Permalink

Comment has been collapsed.
rex2630

Table starts B7 and i must fill all in one function. Points must be from 0-3 points.So if team one won only one match, than there will be 1

8 years ago
Permalink

Comment has been collapsed.
aforce273

Then cell J8 for Team 1 would be:
=SUM(IF(C8>D8,1,0),IF(C8>D8,1,0),IF(C8>D8,1,0))
Team 2 (J9):
=SUM(IF(E8>F8,1,0),IF(E8>F8,1,0),IF(E8>F8,1,0))
Team 3 (J10):
=SUM(IF(G8>H8,1,0),IF(G8>H8,1,0),IF(G8>H8,1,0))

8 years ago
Permalink

Comment has been collapsed.
rex2630

I have score counted like this: =SUM(C8:C10)

8 years ago
Permalink

Comment has been collapsed.
aforce273

What cell is "Tymy" in?

8 years ago
Permalink

Comment has been collapsed.
rex2630

Teams

8 years ago
Permalink

Comment has been collapsed.
rex2630

Thanks very much, buddy.It worked like a charm! :)

8 years ago
Permalink

Comment has been collapsed.

Closed 8 years ago by rex2630.