I think you need to explain in more detail what you are trying to do with
your sumproduct formula, your formula doesn't make any sense
besides being incorrect.


--


Regards,


Peo Sjoblom

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