Re: SUMPRODUCT help

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <BossneedsreportASAP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:38EBE4FD-2359-4C5A-8251-334C2D60D26D@xxxxxxxxxxxxxxxx
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!



.

Quantcast