總和 依起點上下左右及移動數 (12324)

需E9加總=SUM(INDIRECT("R["&A2*-1^(2-(A1="上"))&"]C:R["&IF(A1="下",1,-1)&"]C["&A6*-1^(2-(A5="左"))&"]",))

I9=SUM(OFFSET(E9,IF(A1="上",-1,1),,IF(A1="上",-1,1)*A2,IF(A5="左",-1,1)*(A6+1)))