=SUMPRODUCT(1/(COUNTIF($A$1:$A$23,A1:$A$23)),A1:A23)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"iperlovsky" wrote in message
...
Does anyone know a formula that counts numbers in a range only once when
they
appear. For example: Range includes 1.34 three times, 0.80 five times,
and
0.27 15 times. The count formula counts the range 23 times rather than
the 3
times I am looking for. Any help is greatly appreciated.

Thanks