Elementary SUMPRODUCT Question
I have used this formula to count unique names in a list (from another Banter thread from 2010):
=SUMPRODUCT((B1:B20<"")/COUNTIF(B1:B20,B1:B10&""))
I do not know how this works, especially the / operator. Would someone be willing to explain how this formula works?
Thanks a lot
|