This calculates Wins:
For sumproduct you should use defined ranges instead of whole ranges...![]()
=SUMPRODUCT(--(Schedule!$B$4:$B$408=B4),--(Schedule!$A$4:$A$408>Schedule!$C$4:$C$408))+SUMPRODUCT(--(Schedule!$D$4:$D$408=B4),--(Schedule!$C$4:$C$408>$A$4:$A$408))
Bookmarks