I have a league table spreadsheet, which uses the scores from the fixtures to automatically update it.
It uses SUMPRODUCT to identify whether the matches ended up a win/draw/loss, as well as the goals scored/conceded.
However, one flaw is that any matches currently unplayed (blank) get read as draws. This obviously stops the table working, so if anyone knows how to stop the formula reading the empty cell matches it'd be appreciated.
The formula used in the draws column is:-
=SUMPRODUCT(($A$2:$A$65=J2)*($E$2:$E$65=$F$2:$F$65))
It was suggested to use the IF LEN function and I tried multiple ways, again without success. So I think this will work if I get the formula right.
Bookmarks