View Single Post
  #1   Report Post  
Happens Happens is offline
Junior Member
 
Posts: 2
Default 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