aaaaa34
Board Regular
- Joined
- Feb 25, 2014
- Messages
- 62
hey guys,
file: season.stats italy.xlsx
in attached file, "Fixture" sheet, you ll see results of the league this season.
1- I filtered A column in "Fixture" sheet, HT Total Goals "0"
2- Then I go to "Teams" sheet and I want to write a statistic formula for team "Alessandria" for second half total goals ("Fixture" sheet C column ) Over 1.5 / Under 1.5
HT Total Goals : 0
Home Team: Alessandria
2H Total Goals over 1.5 ("Teams" sheet F3) should be 3
2H Total Goals under 1.5 ("Teams" sheet G3) should be 1
so in "Teams" sheet, how can I write the formula for team Alessandria in F3 and G3 cells ?
file: season.stats italy.xlsx
in attached file, "Fixture" sheet, you ll see results of the league this season.
1- I filtered A column in "Fixture" sheet, HT Total Goals "0"
2- Then I go to "Teams" sheet and I want to write a statistic formula for team "Alessandria" for second half total goals ("Fixture" sheet C column ) Over 1.5 / Under 1.5
HT Total Goals : 0
Home Team: Alessandria
2H Total Goals over 1.5 ("Teams" sheet F3) should be 3
2H Total Goals under 1.5 ("Teams" sheet G3) should be 1
so in "Teams" sheet, how can I write the formula for team Alessandria in F3 and G3 cells ?