加總 二區無順序 (13497)

J2:O7=SUMPRODUCT(($A$2:$A$8=$I2)*($B$1:$F$1=J$1)*$B$2:$F$8)+SUMPRODUCT(($A$10:$A$12=$I2)*($B$9:$F$9=J$1)*$B$10:$F$12)

另解=IFERROR(VLOOKUP($I2,$A$1:$F$6,MATCH(J$1,$A$1:$F$1,),),)+IFERROR(VLOOKUP($I2,$A$9:$F$12,MATCH(J$1,$A$9:$F$9,),),)