return sum of values from a cluster of columns

[Ecel Dumbo]

Hi Friends,

I need help with formula to sum up values from a specified range of columns in “Data” sheet and then drag the formula side ways and down

Please see attached

 

[Hui]

see attached file

 

[Ecel Dumbo]

thank you Hui

 

[bosco_yip]

Another option,

In C5, copied across and down :

=IF($B5="","",SUM(OFFSET(Data!$C$4,MATCH(LOOKUP("zz",Summary!$A$5:$A5),Data!$B$6:$B$16,0)+MATCH(Summary!$B5,Data!$C$6:$C$16,0),MATCH(0+MID(C$3,2,7),Data!$D$2:$BK$2,0),,12)))

Regards
Bosco