Hi,

The following formula counts the unique values in a coulumn. The formula works fine but I am not sure how it works.
I understand how the SUMPRODUCT and COUNTIF functions work. However, I don't understand two things in the following formula.

1. Why is there a division sign (/) in the formula?
2. What is the meaning of the criteria part of the COUNTIF function?


=SUMPRODUCT((E22:E27<>"") / COUNTIF(E22:E27,E22:E27&""))

Thanks,

MG.


Cross posted at http://www.mrexcel.com/forum/showthread.php?t=523476