*Jarom* Wrote:
doesn't seem to be working. :(

What do you mean it doesn't work? The formula is correct and works
fine. Are you trying to reference the entire column? If so, try the
second formula I offered instead...

=SUM(IF(A1:A65535<"",1/COUNTIF(A1:A65535,A1:A65535)))

...entered using CONTROL+SHIFT+ENTER.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=320435