# 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),"")`