(11592) 加總 跳欄多維

R2:T18=SUMPRODUCT(($A$2:$A$10=R$1)*($B$2:$N$10=$Q2)*N(+$C$2:$O$10))

另解{=SUM(IF(($A$2:$A$99=R$1)*($B$2:$N$99=$Q2),$C$2:$O$99))