Non Performing Dealers having Zero Sales

[#1]

Hi All,

I need to find out the No of Non Performing Dealers who having Zero Sales ?? Can any One give me Idea??

Thanks in advance

Regards

Deepak

[#2]

Hey Deepak,

To get a count of the dealers with 0 sales i have used :

=count(if(Sales=0,1))

To get a list of the dealer names this expression may solve your problem:

=if(Match(0,[Sales]),Dealer)

[nizamsha]

if(sum(sales)=0,1,sales)

or if( count(sales)=0,1,Sales)

[#4]

if(sales=0 or sales=' ',Dealers)