Count on multiple columns
 

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

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

Create an additional colum where you sum the values rowwise like in:

=SUM(B2:D2)

in column E. Then invoke:

=COUNT(E2:E50)-COUNTIF(E2:E50,0)

to obtain the desired count.

Emece wrote:
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