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