This seems to be returning the quantity of no in column B where the value in
column A is 2. I need it to return the quantity of "not no" in column B. My
problem may be that I am trying to count actual text instead of numbers so I
have given an example of my actual formula. I only want to count the number
of "B" in column E if "GO BACK" does not appear in column O. Thanks for the
help!

=SUMPRODUCT(--('DISPATCH LOG 12.02.06'!$E:$E="B"),--('DISPATCH LOG
12.02.06'!$O:$O="GO BACK"))

"Bob Phillips" wrote:

=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