Excel: Count Unique (Number) Values

To count the unique number values in a range, say for example column A, you can use a combination of SUM, IF and FREQUENCY formulas.

Example:
=SUM(IF(FREQUENCY(A:A;A:A)>0;1))


Check the help for more details on FREQUENCY formula.