奇偶数位的和相减 (11396)

 B2{=SUM(TEXT(MOD(SUBTOTAL(2,OFFSET(A2,,,ROW(1:98))),2),"0;;!-1")*N(+A2:A99))

另解{=SUM(A:A)-SUM(IFERROR(2*INDEX(A:A,N(IF(1,SMALL(IF(1-ISERR(-A2:A21),ROW(2:21)),ROW(1:10)*2)))),))

慢{=-SUM(N(+A:A)*-1^SUBTOTAL(2,OFFSET(A1,,,ROW(A:A))))

另解{=SUM(N(+A2:A99)*-1^SUBTOTAL(2,OFFSET(A1,,,ROW(1:98))))