=SUMPRODUCT(--(A1:A29=2),--(B2:B20="No"))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Tomkat743" wrote in message
...
How do I count the number of 2's in column A that do not have the word no
in
column B? Answer = 3

A B
1 yes
2 no
2 yes
2 yes
1 maybe
2 maybe