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!

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!

=SUMPRODUCT(--(' Audit Log'!T2:T200='Stats Report'!B10),(--(' Audit
Log'!K2:K200=0))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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!

Thanks Bob, you're the best!!

"Bob Phillips" wrote:

=SUMPRODUCT(--(' Audit Log'!T2:T200='Stats Report'!B10),(--(' Audit
Log'!K2:K200=0))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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!