Emece,

This formula will count the unique entries in A2:C10

=SUMPRODUCT((1/COUNTIF(A2:C10,A2:C10&"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Emece" wrote in message
...
Hi,

I have a worksheet with three columns, each of one stores values sold to
companies in July, August and September. I need to count to how many of
these
companies I have sold sth at least once, for example if I sold to them on
July and August, I only want to count it once.

Hope I am clear enough, need help asap.

Thanks in advance

Regards,
Emece