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,
|