Forum Discussion
Count cells without a specific text
Hi!
I have two colums filled with data.
I need a formula to count the instances of when column A has a certain text, and Column B does NOT have a certain text.
How do I do this?
Example:
TEXT 1 ANSWER 2
TEXT 1 ANSWER 1
TEXT 1 ANSWER 3
TEXT 2 ANSWER 1
I want in a cell, to count the instances where A is "TEXT 1" and B is not "ANSWER 1"
In this exaple the answer would have been 2.
3 Replies
=COUNTIFS(A1:A1000, "TEXT 1", B1:B1000, "<>ANSWER 1")
Hi, tahnks for your reply.
I cant seem to get this to work. Excel says the formula is wrong.
Can you ellaborate maybe?Do you use comma as decimal separator? If so, use semicolons between the arguments of a function:
=COUNTIFS(A1:A1000; "TEXT 1"; B1:B1000; "<>ANSWER 1")
