I am trying to count a text list with many duplicates. I am just trying to
count these unique text fields. I tried using =SUM(1/COUNTIF(B1:B17,B1:B17))
but this just seems to count numbers and not text.

Is there an easy way to do this?
--
MWALL