Count matching values in 2 columns

2438 views excel

how can I count matching values in 2 columns? I tried using this formula. enter image description here

But I'm having #N/A. I should get a value 3.

answered question

1 Answer


Try the following:


Adapted from @BarryHoudini

posted this

Have an answer?


Please login first before posting an answer.