counting differences between Column A and Column B

[oshodibo]

Afternoon People,

is there an IF formula to compare values in two columns, say Column A and Column B have "Action recommended" and column B has "Actual action taken", both columns should have the same texts, in cases where there is no similarity, the formula should count the cases.



Best,

[Kaper]

for instance:
=SUMPRODUCT(1*(A2:A10<>B2:B10))

[oshodibo]

Thanks Kaper,
but the formula is counting the cases where column A and column B are similar, I need it to count the number of cases where they are not similar.

[Kaper]

Yeah, I wrote the answer at 2:38PM, and edited it at 2:40PM, because I noticed it counts opposite than expected. And your answer is 2:52PM (so you probably not noticed my editing) .
Check the same formula but with <> instead of =