Dear all,
I found this function to count cells only once...
=SUMPRODUCT(($A$10:$A$10000<>"")/COUNTIF($A$10:$A$10000,$A$10:$A$10000&""))
It works perfectly but I canīt understand how. the countif gives 0. How can something divided for 0 work?
Thank you for your clarification.
Filippo
Bookmarks