總和 指定縱橫區域 用 RC (11089)

N2=SUM(INDIRECT("R"&L2+1&"C"&L10+1&":R"&L6+1&"C"&L14+1,))

N3=SUM(OFFSET(A1,L2,L10,L6-L2+1,L14-L10+1))

格式化 B2:J16=(ROW(A1)>=$L$2)*(ROW(A1)<=$L$6)*(COLUMN(A1)>=$L$10)*(COLUMN(A1)<=$L$14)