Can someone explain the logic in the formula below? I received it in the weekly excel tip email, I use it, it works, but I don't understand it.

SUMPRODUCT((E9:E210<>"")/COUNTIF(E9:E210,E9:E210&""))

I use it to count the number of unique three letter (text) location codes in the range E9:E210.