View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cougarric Cougarric is offline
external usenet poster
 
Posts: 3
Default 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?