Iddaa Alt Ust Excel -

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

| A | B | C | D | E | F | G | H | |---|---|---|---|---|---|---|---| | Date | League | Home Team | Away Team | Home Goals | Away Goals | Total Goals | Alt/Üst (2.5) | 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