How do I put together the two formulas below to compute for the average?
=IF(INT(INDEX(Summary!$G$12:$P$12,1,MATCH(OFFSET($A$1, 0,INT((COLUMN()-1)/16)*16,1,1),Summary!$G$2:$P$2, 0)))=L$3, INDEX(Summary!$G$12:$P$12,1,MATCH(OFFSET($A$1, 0,INT((COLUMN()-1)/16)*16,1,1),Summary!$G$2:$P$2, 0)), "")
=IF(INT(INDEX(Summary!$G$13:$P$13,1,MATCH(OFFSET($A$1, 0,INT((COLUMN()-1)/16)*16,1,1),Summary!$G$2:$P$2, 0)))=L$3, INDEX(Summary!$G$13:$P$13,1,MATCH(OFFSET($A$1, 0,INT((COLUMN()-1)/16)*16,1,1),Summary!$G$2:$P$2, 0)), "")