SUMIF Variation

Hi there,

Please can you help me adjust this formula so that it simply returns "1" if true and "0" if false.

=SUMIF($BL$2:$BL$1665,$BL27,$CG$2:$CG$1665)

Thank you

What are the conditions that would be true or false?

=If(SUMIF($BL$2:$BL$1665,$BL27,$CG$2:$CG$1665) = 0,0,1)

Thank you for your response.

Not quite what I'm after.

In Example 1, =SUMIF($A$1:$A$3,$A1,$B$1:$B$3) would return 7 against A and 0 against B. What I want to do is return 1 if any value against a group is >1 and 0 if blank or 0 - so A would be 1 and B would 0 as in Example 2.

Example 1
A 2 7
A 2 7
A 3 7
B 0 0
B 0 0

Example 2
A 2 1
A 2 1
A 3 1
B 0 0
B 0 0


Thank you