Hello Everyone,

Just joined this forum.

I Googled out the below formula that counts the number of unique text values from a list. While it does work perfectly fine, but i am unable to understand the logic working behind this formula, especially the reason for using SUMPRODUCT function and A:A&"".

=SUMPRODUCT((A:A<>"")/COUNTIF(A:A,A:A&""))-1

Any explanation will be greatly appreciated.

## Bookmarks