Thank you so much Aladin Akyurek!!
This was exactly what I was lookig for!!
Date | HomeTeam | AwayTeam | FTHG | FTAG |
05/03/2018 | Crystal Palace | Man United | 2 | 3 |
04/03/2018 | Brighton | Arsenal | 2 | 1 |
04/03/2018 | Man City | Chelsea | 1 | 0 |
03/03/2018 | Burnley | Everton | 2 | 1 |
03/03/2018 | Leicester | Bournemouth | 1 | 1 |
03/03/2018 | Liverpool | Newcastle | 2 | 0 |
03/03/2018 | Southampton | Stoke | 0 | 0 |
03/03/2018 | Swansea | West Ham | 4 | 1 |
03/03/2018 | Tottenham | Huddersfield | 2 | 0 |
03/03/2018 | Watford | West Brom | 1 | 0 |
01/03/2018 | Arsenal | Man City | 0 | 3 |
25/02/2018 | Crystal Palace | Tottenham | 0 | 1 |
25/02/2018 | Man United | Chelsea | 2 | 1 |
24/02/2018 | Bournemouth | Newcastle | 2 | 2 |
24/02/2018 | Brighton | Swansea | 4 | 1 |
24/02/2018 | Burnley | Southampton | 1 | 1 |
24/02/2018 | Leicester | Stoke | 1 | 1 |
24/02/2018 | Liverpool | West Ham | 4 | 1 |
24/02/2018 | Watford | Everton | 1 | 0 |
24/02/2018 | West Brom | Huddersfield | 1 | 2 |
12/02/2018 | Chelsea | West Brom | 3 | 0 |
11/02/2018 | Huddersfield | Bournemouth | 4 | 1 |
11/02/2018 | Newcastle | Man United | 1 | 0 |
11/02/2018 | Southampton | Liverpool | 0 | 2 |
10/02/2018 | Everton | Crystal Palace | 3 | 1 |
10/02/2018 | Man City | Leicester | 5 | 1 |
10/02/2018 | Stoke | Brighton | 1 | 1 |
10/02/2018 | Swansea | Burnley | 1 | 0 |
10/02/2018 | Tottenham | Arsenal | 1 | 0 |
10/02/2018 | West Ham | Watford | 2 | 0 |
05/02/2018 | Watford | Chelsea | 4 | 1 |
04/02/2018 | Crystal Palace | Newcastle | 1 | 1 |
04/02/2018 | Liverpool | Tottenham | 2 | 2 |
03/02/2018 | Arsenal | Everton | 5 | 1 |
03/02/2018 | Bournemouth | Stoke | 2 | 1 |
03/02/2018 | Brighton | West Ham | 3 | 1 |
03/02/2018 | Burnley | Man City | 1 | 1 |
03/02/2018 | Leicester | Swansea | 1 | 1 |
03/02/2018 | Man United | Huddersfield | 2 | 0 |
03/02/2018 | West Brom | Southampton | 2 | 3 |
31/01/2018 | Chelsea | Bournemouth | 0 | 3 |
31/01/2018 | Everton | Leicester | 2 | 1 |
31/01/2018 | Man City | West Brom | 3 | 0 |
31/01/2018 | Newcastle | Burnley | 1 | 1 |
31/01/2018 | Southampton | Brighton | 1 | 1 |
I would expect 10; (2+4+2+2)
Thanks for your prompt reply Aladin. However, I am getting a #NUM error with your solution. I have changed the column references as in my sheet I have Column C = Home Team, Column D= Away Team, Column E = Home Goals, Column F= Away Goals. I have Liverpool (or any other team) in K3 and 6 in K2. Perhaps you would be good enough to alter as per my above, but also explain certain parts of your formula. I am particularly confused over the first part where you have =SUM(IF(ROW(............. but use a column ($A$2:$A$46). I don't have many brain cells available for Excel formulas and those I have are confused,