=SUM(MAX(A2,0),MAX(C2,0),MAX(E2,0),MAX(G2,0)) MAX 取兩者最大值。
H2:=SUM(IF(IF(A2:G2>0,A2:G2,0)<>10000,IF(A2:G2>0,A2:G2,0),0))向下複製到H3...