Count on multiple columns

[Guest]

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

 

[Bob Phillips]

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)

 

[Aladin Akyurek]

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

=SUM(B22)

in column E. Then invoke:

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

to obtain the desired count.