Sum up counts in subquery
Does this do what you want?

SELECT SUM(x.records)
FROM 
(
    SELECT COUNT(thecol) AS records
    FROM thetable 
    WHERE thecol IS NOT NULL 
    GROUP BY thecol 
    HAVING COUNT(*) &gt; 1
) AS x