統計各季度 (10757)

M5:P11=SUMPRODUCT((INT(ROW($3:$14)/3)=COLUMN(A1))*$C$5:$I$16*($C$4:$I$4=$L5))

另解=SUMPRODUCT(HLOOKUP($L5,$B$4:$I$16,{2,3,4}+COLUMN(A1)*3-3,))

另解=SUM(OFFSET($B$5,(COLUMN(A1)-1)*3,MATCH($L5,$C$4:$I$4,),3))

另解=SUMPRODUCT((LEN(2^LEFTB($B$5:$B$16,2))=COLUMN(A1))*($C$4:$I$4=$L5)*$C$5:$I$16)

另解=SUMPRODUCT(HLOOKUP($L5,$B$4:$I$16,COLUMN(A1)*3+{-1,0,1},))