Spreadsheet: 673256d1587288858-sum-a-range-including-sub-accounts-formula-query
Sheet: Sheet1

 |  |  | Trying to subtotal the G/L codes below from the data series to the left.
 |  |  | e.g. all totals in column C with 40005, 40010 etc
 | 559524
499999 | 559524.0000000002
40005 | 0.07
40005DT | 643.92 |  | 40005
40005FT | 23825.75 |  | 40010
40005OD | 643.92 |  | 40045
40005QS | 643.91 |  | 40050
40010 | 0.04 |  | 40055
40010DT | 106.87 |  | 40065
40010FT | 3188.42 |  | 40066
40010OD | 160.3 |  | 40075
40010QS | 106.87 |  | 40080
40045 | -0.01 |  | 40117
40045DT | -0.34 |  | 40147
40045FT | -10.2 |  | 40155
40045OD | -0.51 |  | 40167
40045QS | -0.34 |  | 40186
40050 | 34.36 |  | 40227
40050DT | 13.02 |  | 40234
40050FT | 389.85 |  | 40235
40050OD | 19.56 |  | 40240
40050QS | 13.02 |  | 40250
40055 | 180 |  | 40253
40055DT | 84.31 |  | 40255
40055FT | 3121.31 |  | 40260
40055OD | 84.3 |  | 40278
40055QS | 84.3 |  | 40295
40065 | 0.17 |  | 40308
40065DT | 1604.35 |  | 40325
40065FT | 62504.51 |  | 40330
40065OD | 1336.94 |  | 40335
40065QS | 1403.8 |  | 40337
40066 | -0.02 |  | 40357
40066DT | -0.62 |  | 40366
40066FT | -24.41 |  | 40367
40066OD | -0.52 |  | 40370
40066QS | -0.54 |  | 40372
40075 | 1867.18 |  | 40375
40075DT | 1179.55 |  | 40380
40075FT | 19463.48 |  | 40385
40075OD | 1769.36 |  | 40390
40075QS | 1179.56 |  | 40395
40080 | 69.66 |  | 40407
40080DT | 175.66 |  | 40430
40080FT | 8349.18 |  | 40460
40080OD | 263.5
40080QS | 175.66
40117 | 262.27
40117DT | 156.98
40117FT | 4684.49
40117OD | 235.47
40117QS | 156.98
40147 | 136.8
40147DT | 88.31
40147FT | 3268.54
40147OD | 88.31
40147QS | 88.31
40155 | 0.19
40155DT | 721.25
40155FT | 21518.87
40155OD | 1081.92
40155QS | 721.25
40167 | 0.19
40167DT | 47.11
40167FT | 1408
40167OD | 70.77
40167QS | 47.12
40186
40186DT
40186FT
40186OD
40186QS
40227 | 0.04
40227DT | 1355.41
40227FT | 1355.42
40234 | 0.02
40234DT | 10.17
40234FT | 303.52
40234OD | 15.25
40234QS | 10.17
40235 | 1344.19
40235DT | 414.39
40235FT | 15333.79
40235OD | 414.39
40235QS | 2194.39
40240 | 356.08
40240DT | 99.88
40240FT | 3697.28
40240OD | 99.89
40240QS | 99.89
40250DT | 22.5
40250FT | 671.25
40250OD | 33.75
40250QS | 22.5
40253 | 223.61
40255 | 5021.39
40255FT | 8876.81
40255OD | 464.54
40260
40278
40278DT
40278FT
40278OD
40278QS
40295 | 340
40308 | 618
40308DT | 203.94
40308FT | 6084.21
40308OD | 305.91
40308QS | 203.94
40325 | 0.1
40325DT | 74.49
40325FT | 2222.92
40325OD | 111.75
40325QS | 74.49
40330 | 0.01
40330DT | 14.9
40330FT | 444.58
40330OD | 22.35
40330QS | 14.9
40335 | 0.04
40335FT | 4978.92
40335OD | 234.6
40337 | 0.14
40337DT | 391.7
40337FT | 41898.1
40337OD | 639.24
40337QS | 391.7
40357 | 0.06
40357DT | 40.92
40357FT | 1221.57
40357OD | 61.41
40357QS | 40.94
40366 | 5727.14
40367 | 12296.62
40370 | 18967.7
40370DT | 6259.22
40370FT | 186735.01
40370OD | 9388.84
40370QS | 6259.23
40372 | 0.04
40372DT | 18.7
40372FT | 558.21
40372OD | 28.06
40372QS | 18.7
40375 | 41.11
40375DT | 144.78
40375FT | 4319.33
40375OD | 217.13
40375QS | 144.78
40380 | 0.01
40380DT | 13.95
40380FT | 416.17
40380OD | 20.92
40380QS | 13.95
40385 | 222.63
40385DT | 158.94
40385FT | 4742.8
40385OD | 238.43
40385QS | 158.94
40390 | 115.28
40390DT | 50.25
40390FT | 1500.39
40390OD | 75.38
40390QS | 50.25
40395
40407 | 0.02
40407DT | 50.43
40407FT | 1866.09
40407OD | 50.43
40407QS | 50.43
40430 | 0.19
40430DT | 54.98
40430FT | 2036.13
40430OD | 54.98
40430QS | 54.98
40460 | 1880.07
40460DT | 1100.65
40460FT | 20913.1
40100
40100DT
40100FT
40100OD
40100QS
40210
40210DT
40210FT
40210OD
40210QS
40368
40371
40417
40181
40181DT
40181FT
40181OD
40181QS
40215
40215DT
40215FT
40215OD
40215QS
40245DT
40245FT
40245OD
40245QS