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.