部別集計
部署	4月	5月	6月	7月	8月	9月	上期	10月	11月	12月	1月	2月	3月	下期	通期
A部１課	1	2	3	4	5	6	21	7	8	9	10	11	12	57	78
A部２課	11	12	13	14	15	16	81	17	18	19	20	21	22	117	198
A部３課	21	22	23	24	25	26	141	27	28	29	30	31	32	177	318
A部合計	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R6,FIND("_",$R6)-1),COLUMN())&":"&ADDRESS(RIGHT($R6,LEN($R6)-FIND("_",$R6)),COLUMN())))		3_5
B部１課	1	2	3	4	5	6	21	7	8	9	10	11	12	57	78
B部２課	11	12	13	14	15	16	81	17	18	19	20	21	22	117	198
B部合計	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))	=SUM(INDIRECT(ADDRESS(LEFT($R9,FIND("_",$R9)-1),COLUMN())&":"&ADDRESS(RIGHT($R9,LEN($R9)-FIND("_",$R9)),COLUMN())))		7_8