Try this:

=SUMPRODUCT((B1:B17<"")/COUNTIF(B1:B17,B1:B17&""))


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"MWall" wrote:

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