Better formula please

[Haha88]

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.

[Pecoflyer]

A better formula? What's wrong with this one?

[Haha88]

Nothing wrong with the formula but I thought there's may be a better/shorter formula than above.
I'm looking for
=SUMIF('Group Consolidated'!$C$2:$AL$2,CONCATENATE(B$8,".",B$9),
return of
=sum('Group Consolidated'!$C$49:$AL$49,'Group Consolidated'!$C$74:$AL$74)
rather than have to form 2 x sumif.
Is it possible?
Thanks,