Basic help needed using sumproduct to do a league table
I have created a fairly basic league table that uses SUMPRODUCT to extract
games won/drawn/lost from a list of fixtures.
This works fine. However, the fixtures that are blank get counted as draws.
How do I make sumproduct only read cells that have an entry in them?
|