• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

return sum of values from a cluster of columns

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
 

Attachments

  • Excel Query.xlsx
    24.7 KB · Views: 8
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
 

Attachments

  • Excel Query (1).xlsx
    25.5 KB · Views: 6
Back
Top