總和 多維數據 (10869)

C11=SUM((T(OFFSET(A$1,{1;2;3;4},{0,3,6,9}))=A11)*(T(OFFSET(B$1,{1;2;3;4},{0,3,6,9}))=B11)*N(OFFSET(C$1,{1;2;3;4},{0,3,6,9})))

另解=SUMIFS($C$2:$Z$5,$A$2:$X$5,$A11,$B$2:$Y$5,$B11)

另解=SUMIFS(OFFSET($C$2,,,4,COUNTA($1:$1)-2),OFFSET($A$2,,,4,COUNTA($1:$1)-2),$A11,OFFSET($B$2,,,4,COUNTA($1:$1)-2),$B11)

另解{=SUM(IFERROR(($A$2:$J$5=A11)*($B$2:$K$5=B11)*($C$2:$L$5),))