On 30 Nov, 10:06, Andrew@rushington
wrote:
can i use countif to count the how many different values exist in a column.

Assume Col A you want to count a list of uniques (excluding blanks)
within A1:A1000:

=SUMPRODUCT((A1:A1000<"")/COUNTIF(A1:A1000,A1:A1000&""))

Richard