Iddaa Alt Ust — Excel

=IF(G2>2.5, "Üst", "Alt") | A | B | C | D | E | |---|---|---|---|---| | Team | Avg Goals Scored (Home) | Avg Goals Conceded (Home) | Avg Goals Scored (Away) | Avg Goals Conceded (Away) |

=AVERAGEIFS(MatchDB!E:E, MatchDB!C:C, A2) Then calculate for a fixture: Iddaa alt ust excel

=E2+F2 Formula for (Column H) – assuming 2.5 line: =IF(G2>2

Use AVERAGEIFS to pull data from the Match Database. Example for home scoring average: Iddaa alt ust excel