[請問] Excel連續欄位加總
A B
1 1 =SUM(A1:A3)
2 22 =SUM(A1:A3)
3 31 =SUM(A1:A3)
4
5
6 51 =SUM(A6:A7)
7 33 =SUM(A6:A7)
8
9
10
11
12
13 90 =SUM(A13:A19)
14 71 =SUM(A13:A19)
15 68 =SUM(A13:A19)
16 22 =SUM(A13:A19)
17 3 =SUM(A13:A19)
18 55 =SUM(A13:A19)
19 42 =SUM(A13:A19)
20
欲將A欄連續出現的欄位加總後到放B欄
連續出現的欄位數目不一 空欄位的數目也不規律
不知道有沒有公式可解決?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.250.129.79
※ 文章網址: https://www.ptt.cc/bbs/ask/M.1455602822.A.289.html
→
02/17 13:34, , 1F
02/17 13:34, 1F
推
02/17 16:05, , 2F
02/17 16:05, 2F
→
02/18 01:42, , 3F
02/18 01:42, 3F
→
02/18 01:44, , 4F
02/18 01:44, 4F
→
02/18 01:44, , 5F
02/18 01:44, 5F