Countif ?
 

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

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

Countif ?
 

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

Countif ?
 

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

Countif ?
 

Simple adjustment

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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Tomkat743" wrote in message
...
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