Hi

Is there better formula to trim down the below sumif function?

=SUMIF('Group Consolidated'!$C$2:$AL$2,CONCATENATE(B$8,".",B$9), 'Group Consolidated'!$C$49:$AL$49)+SUMIF('Group Consolidated'!$C$2:$AL$2,CONCATENATE(B$8,".",B$9), 'Group Consolidated'!$C$74:$AL$74)

Many thanks.