Hi,
Already asked a few questions about this spreadsheet I'm creating and this forum has been a lifesaver. Thanks so much all!
The question I now have:
I have a sheet of football results that I am analysing in detail be team. My result sheet is E0 12-13 (see attached sheet). On my analysis sheet I now want to work out the number of instances of 0-0, 0-1, 0-2 etc. results in the second half.
As you can see I've done this fine for the full time result and the half time result as it's easier as E0 12-13 contains columns for Full Time Home Goals (E), Full Time Away Goals (F), Half Time Away Goals (H), Half Time Away Goals (I).
Let's take 0-0 as the example. To create the instances that the second half (excluding what happened in the first half) was 0-0 I have tried the following formla:
=SUMPRODUCT(('E0 12-13'!$C$1:$C$1000=$A$4)*('E0 12-13'!$E$1:$E$1000-'E0 12-13'!$H$1:$H$1000=0)*('E0 12-13'!$F$1:$F$1000-'E0 12-13'!$H$1:$H$1000=0))
Essentially trying to get Full Time minus Half Time goals to leave me with the number of goals in the second half for each team, and then to search when those instances were both 0.
However the formula is returning and error "VALUE". Any ideas what I'm doing wrong?
Thanks,
Alex
Bookmarks