countif & and
 

What am I doing wrong? I need to count the number of "Yes" in column W for
all entries with a 72 in column A

=countif(and($a$4:$a$300,72),$w$4:$w$300,"Yes"))

countif & and
 

Your formula is somewhat strange! What is easiest is to use the
sumproduct function
=SUMPRODUCT(($A$4:$A$300=72)*($W$4:$W$300="Yes"))

Should work. When the condition proves to be true it returns a true
else a false

so when both conditions are true their product (true*true)=1
when only one condition is true (true*false)=0
when non conditions are true (false*false)=0

the sum of these products (as they are all 1) is the same as a count

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=514416

countif & and
 

You need to have a dummy column say AA, which checks for the 72 and the
"Yes", AA67=IF(AND( A67=72,W67="Yes"),"Y","N").Hide the column AA, if you
want. The do a =COUNTIF($AA$4:$AA$300,"Y").

"Charlie7805" wrote:

What am I doing wrong? I need to count the number of "Yes" in column W for
all entries with a 72 in column A

=countif(and($a$4:$a$300,72),$w$4:$w$300,"Yes"))