Hi!

Try this:

=SUMPRODUCT((A1:A19<"")/COUNTIF(A1:A19,A1:A19&""))

Biff

"sharder" wrote in
message ...

I have a list that show mulitple times in my spreedsheet and I need to
know how many actual numbers are there Ex: I actually have 5 orders
here.
398805
398805
398805
516878
516878
516878
540836
540836
540836
540836
540836
567585
567585
567585
567585
567911
567911
567911
567911
Thanks for your help


--
sharder
------------------------------------------------------------------------
sharder's Profile:
http://www.excelforum.com/member.php...o&userid=25488
View this thread: http://www.excelforum.com/showthread...hreadid=556605