Group Selection & Sum Query

[swana2k]

Hi All,

Looking for some assistance please - which I'm sure must be a pretty straight forward for those that know how (not myself!)...

I have a list of customers (A) and a 'live' count (just a zero or one) in column (B) - basically I just want to identify only those customers where the the SUM for that customer of (B) equals zero i.e. if any of (B) equals 1 then exclude from selection.

In the cross section below, customers highlighted in green would be selected - all others would be excluded as either all (B) or at least one row = 1.

Thanks in advance.

 

[hagia_sofia]

Hello, depending on whether you would like to see a whole list or a unique list:

=FILTER(A2:A36,NOT(SUMIFS(B2:B36,A2:A36,A2:A36)))

=UNIQUE(FILTER(A2:A36,NOT(SUMIFS(B2:B36,A2:A36,A2:A36))))

 

[swana2k]

Thank you!