Matching numbers in two Columns

[tikrit]

Hello,

This is my second question here. You helped me with my first one, Thank you.

I have the following columns (O & S):

S O
-----
1 3
3 7
6 6
8 4
1 3
2 8
1 6

I want a code (Formula) do the follwoing: Matching number 1 in column S with number 3 in Column O and count how many matches found in the two columns, Which in this case only two.

Thanks in advance for all

 

[tikrit]

Hello tikrit,

If you are on Excel 2007 or later, COUNTIFS is one option.

=COUNTIFS(S2:S100,1,O2:O100,3)

Or, this will work with all versions.

=SUMPRODUCT((S2:S100=1)*(O2:O100=3))

Haseeb.... It's working ! Thank you.

 

[tikrit]

Hello tikrit,

If you are on Excel 2007 or later, COUNTIFS is one option.

=COUNTIFS(S2:S100,1,O2:O100,3)

Or, this will work with all versions.

=SUMPRODUCT((S2:S100=1)*(O2:O100=3))

Hasseb, It's working ... Your simple code is great ... Thank you Dear

 

[tikrit]

@ Rick & Robert

Thank you so much