I am working with 2 worksheets, Audit Log and Stats Report. I have a count
if function working properly - =COUNTIF(' Audit Log'!T:T,'Stats Report'!B10)
where T is a column of week numbers and B10 is week 15 (=WEEKNUM(A10)).

Now I need to use the above count if combined with =COUNTIF(' Audit
Log'!K:K,0) where K is a number ranging from 0 to 10

=SUMPRODUCT((' Audit Log'!T:T,'Stats Report'!B10),0) returns #VALUE!