Countif ?
=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
|