移動後 計算總值 (15180)

F2=D$2+SUMPRODUCT(E2*TEXT(FIND(B$2:B$11,"上下左右")-2,"!0;-1;1"))

另解=H$2+I2*SUM(COUNTIF(B:F,{"上","下"})*{-1,1})