Hi Everyone.
this might be a very simple question to answer, but for some reason i cant figure it out so i am reaching out to anyone that knows more then me (that would be a lot of people lol)
lets say in the football matches played,
Spain has one match with one goal, and it did not end 0-0 or 1-1, so i want a 0 returned,
Australia have 2 matches, one with more then 3 goals and one that ended 1-1, so i want a return of 2
England has 6 matches, 2 that ended 1-1 and no matches had over 3 goals, so here i want a return of 2.
i have tried vlookup, sumproduct and match, but i am just not clever enough to figure this one out, can anyone point me in the correct direction
please and thanks
this might be a very simple question to answer, but for some reason i cant figure it out so i am reaching out to anyone that knows more then me (that would be a lot of people lol)
lets say in the football matches played,
Spain has one match with one goal, and it did not end 0-0 or 1-1, so i want a 0 returned,
Australia have 2 matches, one with more then 3 goals and one that ended 1-1, so i want a return of 2
England has 6 matches, 2 that ended 1-1 and no matches had over 3 goals, so here i want a return of 2.
i have tried vlookup, sumproduct and match, but i am just not clever enough to figure this one out, can anyone point me in the correct direction
please and thanks
league | home | away | Total goals | 0 | 1 | 2 | 3 | 4 | 5 | 6 | |||
France | 0 | 0 | 0 | France | |||||||||
Germany | 3 | 1 | 4 | Germany | |||||||||
Italy | 1 | 0 | 1 | Italy | |||||||||
Spain | 1 | 0 | 1 | Spain | |||||||||
Australia | 4 | 0 | 4 | Australia | |||||||||
Australia | 1 | 1 | 2 | England | |||||||||
England | 1 | 2 | 3 | ||||||||||
England | 1 | 1 | 2 | ||||||||||
England | 0 | 3 | 3 | 0-0 + 1-1 + 3 or more goals | |||||||||
England | 1 | 0 | 1 | France | |||||||||
England | 1 | 1 | 2 | Germany | |||||||||
England | 1 | 0 | 1 | Italy | |||||||||
France | 1 | 2 | 3 | Spain | 0 | ||||||||
France | 2 | 1 | 3 | Australia | |||||||||
Germany | 5 | 1 | 6 | England | |||||||||
Germany | 3 | 2 | 5 | ||||||||||
Germany | 3 | 1 | 4 | ||||||||||
Germany | 2 | 0 | 2 | ||||||||||
Germany | 0 | 1 | 1 |