統計每日各區和 (9830)

V2:Z2=SUM(OFFSET($A2:$D5,,COLUMN(A1)*4-4))

另解 V2:Z2=SUM(OFFSET($A2:$D5,,LEFTB(V1,2)*4-4))

V10:Z10{=SUM(OFFSET($A10,,MATCH(V9,9:9,)-1,4,SUM(N(LOOKUP(COLUMN($A:$T),COLUMN($A:$T)/($A9:$T9>""),$A9:$T9)=V9))))