---
# System prepended metadata

title: excel group 內數量

---

# excel group 內數量
|     | A      | B   | C    |
| --- | ------ | --- | ---- |
| 1   | 組     |     | 數量 |
| 2   | 第一組 | 456 | 5    |
| 3   |        | 789 |      |
| 4   |        | 1   |      |
| 5   |        | 23  |      |
| 6   |        | 46  |      |
| 7   | 第二組 | 84  | 4    |
| 8   |        | 1   |      |
| 9   |        | 1   |      |
| 10  |        | 1   |      |
| 11  | 第三組 | 456 | 3    |
| 12  |        | 565 |      |
| 13  |        | 15  |      |
| 14  | 第四組 | 15  | 1    |


C2公式=`IF(A2<>"",IFNA(ROW(INDEX(A3:A$1048576,MATCH(TRUE,INDEX((A3:A$1048576<>0),0),0)))-LOOKUP(2,1/(A$2:A2<>""),ROW(A$2:A2)),1),"")`

