Dear all,

I would like to count the no. of companies who would not come (RSVP). I have the formula

Formula: copy to clipboard 
=SUM(--(FREQUENCY(IF(List!$S$6:$S$2000<>"Y",IF(List!$R$6:$R$2000=A11,MATCH(List!$F$6:$F$2000,List!$F$6:$F$2000,0))),ROW(List!$F$6:$F$2000)-ROW(List!$F$6)+1)>0))



Organisation Name is column F, S is attend, R is guest type


Guest name are listed in rows as below:

Organisation Name (Eng) Guest Type "Attend
(Y/N)"
A company 6th N
A company 6th Y
A company 6th Y
B company 6th N
B company 6th Y
B company 6th N
C company 6th Y
C company 6th Y
D company 6th N
D company 6th N

However, the formula would calculate those company who would come but with one representative not coming as it would be listed as "N" as well. I only would like to count those companies with all names are of "N". Could anybody advise? Thanks a lot!

Regards,
Carol