I've never used SumProduct before so I've cobbled this together after a bit of googling. The Sumproduct works great and reports what I would expect but I need to eek out more to get what I need.
Here is the formula that I wanted to use.....
=COUNTIFS(O:O,0,Q:Q,"No",R:R,"<" & N:N)...