Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |