Using COUNTIF with an AND? Or is it something different?

[Paul Franklin]

Hello,

I hope that someone would be able to point me in the right direction as
I seem to have been working on my problem for some time without success.

Here is the situation:

I have two columns that I want to use. Column V will have numbers
between 1 and 52 (week numbers). Column D will have a "Y" or a "N".

In column E I want to be able to count the number of times when a
certain week number appears in column V but only where there is a "Y" in
the corresponding row of column D. So far I have tried a number of
combinations (all of which have errors), such as....

=COUNTIF(AND(V159:V600,"12",D159600,"Y") or
=AND COUNTIF(V159:V600,12,(D159600,Y))

Clearly I am way off the mark so please could someone help? I would be
extremely grateful......

Thank you.

Paul.

*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

=SUMPRODUCT(--(V159:V600=12),--(D159600="Y"))

--
---
HTH

Bob

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