往下計算余额 (9142)

B7=SUMPRODUCT(-1^(A1:A6="减")*B1:B6)

另解=MMULT(SUMIF(A1:A6,{"*","减"},B1:B6),{1;-2})

另解=SUM(SUMIFS(B:B,A:A,"<>"&A7,A:A,{"*";"减"})*{1;-2})

G1=F1

G2:G6=CHOOSE(FIND(E2,"加减乘除"),G1+F2,G1-F2,G1*F2,G1/F2)

F7=LOOKUP(9^9,G:G)