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