Formula required for counting duplicate values

[Arunkumaramk]

Dear Team,

Can anyone help me with the formula to count only the duplicate values in a column.
The column will be in number format.

[FDibbins]

To get the best responses, upload a sample workbook - see the yellow banner above

[hrlngrv]

If you mean that for the numbers {1;2;2;3;3;4;5;5;6;7;7;8;9;10;11;11;12;13;13;14;15;16} you want the count to be 6, that is, 6 distinct values appear more than once,

=SUMPRODUCT(--(FREQUENCY(range,range)>1))

If you mean something else, you need to provide more details/be more specific describing what you seek.