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.
29 Comments - Last post 10 minutes ago by Chris76de
1,314 Comments - Last post 51 minutes ago by VicViperV
15,398 Comments - Last post 1 hour ago by CommissarCiaphasCain
1,081 Comments - Last post 1 hour ago by Gamy7
46,823 Comments - Last post 3 hours ago by FranckCastle
1,408 Comments - Last post 6 hours ago by Conti
38 Comments - Last post 8 hours ago by BattleChaing
523 Comments - Last post 1 minute ago by EvaUnits
5 Comments - Last post 26 minutes ago by RePlayBe
105 Comments - Last post 27 minutes ago by Shanti
28 Comments - Last post 38 minutes ago by DrR0Ck
28 Comments - Last post 52 minutes ago by ChocolateVC
868 Comments - Last post 55 minutes ago by juansebastian28
101 Comments - Last post 56 minutes ago by Carenard
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.