Spreadsheet: 853363d1703237348-sumproduct-with-dynamic-ranges-football-results-v1
Sheet: ANALYSIS TAB

 | Rows of Data in 'Master [NAME]
 | HOME TEAM |  | AWAY TEAM | Total Goals | Matches | Average Goals per Match | 1.5+ Goals # | 1.5+ Goals % | 2.5+ Goals # | 2.5+ Goals % | 3.5+ Goals # | 3.5+ Goals % | HOME 2+ # | HOME 2+ % | AWAY 2+ # | AWAY 2+ %
 | Fulham | Vs. | Burnley
 | Luton | Vs. | Newcastle
 | Nott'm Forest | Vs. | Bournemouth
 | Tottenham | Vs. | Everton
 | [NAME] | Vs. | Watford
 | Leicester | Vs. | Rotherham
 | Middlesbrough | Vs. | West Brom
 | [NAME] | Vs. | Huddersfield
 | Plymouth | Vs. | Birmingham
 | QPR | Vs. | Southampton
 | Sheffield Weds | Vs. | Cardiff
 | Stoke | Vs. | Millwall
 | Sunderland | Vs. | Coventry
 | Barnsley | Vs. | Stevenage
 | Blackpool | Vs. | [NAME]
 | [NAME] | Vs. | Leyton Orient
 | Carlisle | Vs. | Cheltenham
 | Charlton | Vs. | [NAME]
 | Northampton | Vs. | Oxford
 | Portsmouth | Vs. | Fleetwood Town
 | Reading | Vs. | [NAME]
 | Shrewsbury | Vs. | Peterboro
 | Wycombe | Vs. | Port Vale
 | Accrington | Vs. | Walsall
 | [NAME] | Vs. | Harrogate
 | Morecambe | Vs. | [NAME]
 | Sutton | Vs. | Mansfield
 | Tranmere | Vs. | Swindon
 | [NAME] | Vs. | Newport County
 | Fylde | Vs. | Dag and Red
 | Barnet | Vs. | [NAME]
 | Chesterfield | Vs. | Aldershot
 | Eastleigh | Vs. | Dorking
 | Halifax | Vs. | Rochdale
 | Kidderminster | Vs. | Southend
 | Oldham | Vs. | Gateshead
 | Oxford City | Vs. | Solihull
 | Wealdstone | Vs. | Hartlepool
 | Woking | Vs. | Maidenhead
 | York | Vs. | Ebbsfleet
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.
 |  | Vs.