I have a long list of numbers & some cells are blank & others have NA. I would like to count all the cells that has a repeating value so for example:

1835073
1611044
1681644
1510431
1630061
1842588

The returned value would be 4 = 1 (1611044) + 1 (1681644) + 1 (1630061) + 1 (1842588) because these cells have a repeating number somewhere in the string of text.

I tried using this formula however I get a weird number & instead of sitting here killing myself reading over 46 thousand records, I need the formula to do the counting for me!

=SUM(COUNTIF(F:F, "??"))
Would there be a different formula if the cell was text? Thank you for any help in advance!