Similar to Q re 2 Countifs, but Sumproduct doesn't work

[jtujague]

I am using this formula to count the number of times that a column M is

=0.5% in the prior 100 days (given as the Referce L$23), only if there is a

matching "type" in column K.

SUMPRODUCT((OFFSET(K124,1-L$23,,L$23,1)=K125*(OFFSET(M124,1-L$23,,L$23,1)>=V20)))

But this is not working.

I also tried
COUNTIF(OFFSET(K124,1-L$23,,L$23,1),K125-(COUNTIF(OFFSET(M124,1-L$23,,L$23,1),"<.005"))))

But this did not work either.

Both formulas returned a value of "0" when it should not be 0.

Thanks.