"Ola" wrote...
...and that should be...
=SUMPRODUCT(--( (A1:A3 & B1:B3 & C1:C3) = (A1 & B1 & C1) ) )

I added a few " " to make it easier to read.

Why test A1:A3 against itself? It'll obviously be true.

=1+SUMPRODUCT(--((A2:A3&B2:B3&C2:C3)=(A1&B1&C1)))

But this is a classic bug in waiting. This may work with the OP's sample
data, but will fail in cases like

3 11 54
2 5 45
31 15 4

Far better to keep the comparisons separate.

=1+SUMPRODUCT((A2:A3=A1)*(B2:B3=B1)*(C2:c3=C1))