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?
Comment has been collapsed.
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))
Comment has been collapsed.
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.
Comment has been collapsed.
1,713 Comments - Last post 1 minute ago by eeev
329 Comments - Last post 14 minutes ago by Banortwi
49 Comments - Last post 22 minutes ago by Atombomb2097
34 Comments - Last post 38 minutes ago by malkavian1331
34 Comments - Last post 1 hour ago by OneManArmyStar
3 Comments - Last post 1 hour ago by lostsoul67
371 Comments - Last post 1 hour ago by Atombomb2097
77 Comments - Last post 4 minutes ago by zevnda
10,786 Comments - Last post 27 minutes ago by Talleyrand
42 Comments - Last post 30 minutes ago by Ugluck
41 Comments - Last post 32 minutes ago by BoBsync
601 Comments - Last post 55 minutes ago by RePlayBe
17,827 Comments - Last post 1 hour ago by GeekDoesStuff
70 Comments - Last post 1 hour ago by RePlayBe
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:
Comment has been collapsed.