try
=SUMPRODUCT(--(FREQUENCY(A1:A14,A1:A14)=2))
change range reference as needed

"Rothman" wrote:

I have a column of random numbers. Is there a way of counting the numbers
that appear the same, given number of times in the column in a formula? For
instance, if numbers a, b and c appear x times, then the answer would be 3.

Thanks in advance.