Home 
Search 
Today's Posts 
#1




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 
#2




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 
#3




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 
#4




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 
#5




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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
sumproduct vs. countif  Excel Discussion (Misc queries)  
Countif Formula /Sort Bug???  Excel Discussion (Misc queries)  
COUNTIF or not to COUNTIF on a range in another sheet  Excel Worksheet Functions  
Combining IF and COUNTIF based on two columns  Excel Discussion (Misc queries)  
Countif  Countif  Excel Worksheet Functions 