總和 符合多條件的合计列 (13549)

N2=SUMPRODUCT((MMULT(COUNTIF(OFFSET(A1,ROW(1:8),COLUMN(A:J)),">"&{5,0,3,0,7,0,0,0,0,0}),ROW(1:10)^0)=10)*L2:L9)

另解=SUMPRODUCT((MMULT(COUNTIF(OFFSET(A1,ROW(1:8),{1,3,5}),">"&{5,3,7}),{1;1;1})=3)*(MMULT(N(B2:K9>0),ROW(1:10)^0)=10)*L2:L9)