總和 縱或橫不固定 (14408)

B2{=IFERROR(SUM(VLOOKUP(A2,F:M,COLUMN(B:G),)),)+IFERROR(SUM(HLOOKUP(A2,G$1:M$8,ROW($2:$8),)),)

另解=SUMPRODUCT(((F$2:F$8=A2)+(G$1:M$1=A2))*G$2:M$8)