Excel Formula Help

[ststern45]

Hi everyone,

My question is this:

Cell A1 = 3
Cell A2 = 3

Cell B1 = 0
Cell B2 = 1

Cell C1 = 2
Cell C2 = 2

Need a formula that count the total number of times a digit repeats from the cell below.

So using the example above the total = 2 since the 3 repeated in cells A1 & A2 and also 2 repeated in cells C1 and C2.

The minimum value = 0
The maximum value = 3

Cells A1 & A2 = Position 1
Cells B1 & B2 = Position 2
Cells C1 & C2 = Position 3

Thanks in advance!!

 

[Tetra201]

Try

=SUMPRODUCT(--(A1:C1=A2:C2))

 

[Trebor76]

Never mind. Tetra201's solution is far better.

 

[ststern45]

Thanks for all your help.
I actually used this: Probably a shorter version...
=MIN(IF(COUNTIF($AM20,$AM21)>0,1)+IF(COUNTIF($AN20,$AN21)>0,1)+IF(COUNTIF($AO20,$AO21)>0,1),IF(COUNTIF($AM21,$AM20)>0,1)+IF(COUNTIF($AN21,$AN20)>0,1)+IF(COUNTIF($AO21,$AO20)>0,1))