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

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",D159:D600,"Y") or
=AND COUNTIF(V159:V600,12,(D159:D600,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 ***

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

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

--
---
HTH

Bob

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



"Paul Franklin" wrote in message
...
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",D159:D600,"Y") or
=AND COUNTIF(V159:V600,12,(D159:D600,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 ***