It seems to stop blanks in the range from causing the formula to return an
error message, but I'm not sure I see why.
--
tj


"tjtjjtjt" wrote:

I've seen formulas like this posted as a solution for counting unique items
in a column:
=SUMPRODUCT((A1:A20000<"")/COUNTIF(A1:A20000,A1:A20000&""))

What purpose does the &"" at the end serve?

--
tj