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

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.

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

No idea what is in all those cells, but maybe

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


--
__________________________________
HTH

Bob

"jtujague" wrote in message
...
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.