Tomkat

Something like

=SUMPRODUCT((A1:A6=2)*(B1:B6="No"))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"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