Count matching values in 2 columns

2438 views excel
4

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

5

Try the following:

=SUMPRODUCT((COUNTIF(B1:B5,C1:C3)>0)+0)

Adapted from @BarryHoudini

posted this

Have an answer?

JD

Please login first before posting an answer.