Spreadsheet: 829393d1684178022-formula-to-sum-based-condition-and-range-of-account-numbers-sample-for-forum
Sheet: Expenditures

 | Account Code | Code 1 | Pay Period | Code 3 | Code 4 | Pay Time Scale | Cost Center | Description | Expenditures | Projected | Adjustments | Projection with Adjustments
 |  |  | 51100 |  |  | bi-weekly | ICF/MR |  | 6503 |  | 918
 |  |  | 59110 |  |  | bi-weekly | ICF/MR |  | 8019 |  | 1370
 |  |  | 59120 |  |  | bi-weekly | ICF/MR |  | 6860 |  | 739
 |  |  | 59130 |  |  | bi-weekly | ICF/MR |  | 231 |  | 17
 |  |  | 59140 |  |  | bi-weekly | ICF/MR |  | 3201 |  | 1481
 |  |  | 59150 |  |  | bi-weekly | ICF/MR |  | 5488 |  | 685
 |  |  | 59160 |  |  | bi-weekly | ICF/MR |  | 757 |  | 1091
 |  |  | 59170 |  |  | bi-weekly | ICF/MR |  | 5651 |  | 1312
 |  |  | 59190 |  |  | bi-weekly | ICF/MR |  | 2349 |  | 1357
 |  |  | 59200 |  |  | bi-weekly | ICF/MR |  | 3689 |  | 45
 |  |  | 59210 |  |  | bi-weekly | ICF/MR |  | 5000 |  | 1386
 |  |  | 59220 |  |  | bi-weekly | ICF/MR |  | 8410 |  | 762
 |  |  | 59230 |  |  | bi-weekly | ICF/MR |  | 6399 |  | 1270
 |  |  | 59240 |  |  | bi-weekly | ICF/MR |  | 8085 |  | 1448
 |  |  | 59250 |  |  | bi-weekly | ICF/MR |  | 3935 |  | 1478
 |  |  | 59260 |  |  | bi-weekly | ICF/MR |  | 5519 |  | 1068
 |  |  | 60100 |  |  | monthly | ICF/MR |  | 322 |  | 733
 |  |  | 60110 |  |  | monthly | ICF/MR |  | 8740 |  | 233
 |  |  | 60120 |  |  | monthly | CLA |  | 3839 |  | 84
 |  |  | 60130 |  |  | monthly | ICF/MR |  | 2982 |  | 687
 |  |  | 60140 |  |  | monthly | ICF/MR |  | 4871 |  | 189
 |  |  | 60150 |  |  | monthly | ICF/MR |  | 9180 |  | 1440
 |  |  | 60170 |  |  | monthly | ICF/MR |  | 7310 |  | 99
 |  |  | 60180 |  |  | monthly | ICF/MR |  | 2416 |  | 1408
 |  |  | 60190 |  |  | monthly | ICF/MR |  | 9095 |  | 758
 |  |  | 60200 |  |  | monthly | ICF/MR |  | 645 |  | 1138
 |  |  | 60210 |  |  | monthly | ICF/MR |  | 829 |  | 171
 |  |  | 60220 |  |  | monthly | ICF/MR |  | 3868 |  | 1292
 |  |  | 60230 |  |  | monthly | ICF/MR |  | 1474 |  | 422
 |  |  | 60235 |  |  | monthly | ICF/MR |  | 6866 |  | 1210
 |  |  | 60240 |  |  | monthly | Community |  | 1797 |  | 838
 |  |  | 60250 |  |  | monthly | Mat |  | 4676 |  | 420
 |  |  | 60260 |  |  | monthly | ICF/MR |  | 4091 |  | 1412
 |  |  | 60265 |  |  | monthly | ICF/MR |  | 5906 |  | 1244
 |  |  | 60280 |  |  | monthly | ICF/MR |  | 9692 |  | 179
 |  |  | 60290 |  |  | monthly | ICF/MR |  | 9019 |  | 582
 |  |  | 60300 |  |  | monthly | ICF/MR |  | 7260 |  | 1311
 |  |  | 60310 |  |  | monthly | ICF/MR |  | 7820 |  | 1061
 |  |  | 60320 |  |  | monthly | ICF/MR |  | 4473 |  | 916
 |  |  | 62100 |  |  | monthly | ICF/MR |  | 4382 |  | 176
 |  |  | 62110 |  |  | monthly | ICF/MR |  | 6831 |  | 754
 |  |  | 62120 |  |  | monthly | Community |  | 6810 |  | 737
 |  |  | 62130 |  |  | monthly | ICF/MR |  | 7351 |  | 1204
 |  |  | 62200 |  |  | monthly | ICF/MR |  | 5543 |  | 1466
 |  |  | 62210 |  |  | monthly | ICF/MR |  | 5203 |  | 1205
 |  |  | 62220 |  |  | monthly | ICF/MR |  | 6516 |  | 353
 |  |  | 62230 |  |  | monthly | CLA |  | 4820 |  | 127
 |  |  | 62240 |  |  | monthly | Mother |  | 2523 |  | 522
 |  |  | 62250 |  |  | monthly | ICF/MR |  | 2187 |  | 1124
 |  |  | 62260 |  |  | monthly | ICF/MR |  | 637 |  | 963
 |  |  | 62300 |  |  | monthly | ICF/MR |  | 7548 |  | 506
 |  |  | 62310 |  |  | monthly | CLA |  | 3811 |  | 457
 |  |  | 62320 |  |  | monthly | ICF/MR |  | 3578 |  | 682
 |  |  | 62330 |  |  | monthly | ICF/MR |  | 9445 |  | 356
 |  |  | 62400 |  |  | monthly | ICF/MR |  | 4086 |  | 323
 |  |  | 62410 |  |  | monthly | ICF/MR |  | 5945 |  | 341
 |  |  | 62500 |  |  | monthly | Community |  | 8832 |  | 1491
 |  |  | 62510 |  |  | monthly | ICF/MR |  | 7682 |  | 1056
 |  |  | 62520 |  |  | monthly | Outpatient |  | 5736 |  | 1361
 |  |  | 64100 |  |  | monthly | ICF/MR |  | 8584 |  | 832
 |  |  | 64110 |  |  | monthly | ICF/MR |  | 9646 |  | 78
 |  |  | 64120 |  |  | monthly | ICF/MR |  | 2524 |  | 1221
 |  |  | 64130 |  |  | monthly | ICF/MR |  | 5588 |  | 383
 |  |  | 64140 |  |  | monthly | Outpatient |  | 6214 |  | 434
 |  |  | 64141 |  |  | monthly | ICF/MR |  | 1483 |  | 404
 |  |  | 64150 |  |  | monthly | ICF/MR |  | 3738 |  | 746
 |  |  | 64160 |  |  | monthly | ICF/MR |  | 4754 |  | 1206
 |  |  | 64190 |  |  | monthly | ICF/MR |  | 7006 |  | 660
 |  |  | 64200 |  |  | monthly | ICF/MR |  | 4401 |  | 1036
 |  |  | 64230 |  |  | monthly | ICF/MR |  | 1750 |  | 883
 |  |  | 64400 |  |  | monthly | ICF/MR |  | 9048 |  | 1311
 |  |  | 64410 |  |  | monthly | ICF/MR |  | 3187 |  | 845
 |  |  | 64420 |  |  | monthly | ICF/MR |  | 6836 |  | 182
 |  |  | 64430 |  |  | monthly | ICF/MR |  | 4772 |  | 1361
 |  |  | 64600 |  |  | monthly | Mat |  | 3230 |  | 538
 |  |  | 64610 |  |  | monthly | Adopt |  | 5030 |  | 863
 |  |  | 67100 |  |  | monthly | ICF/MR |  | 965 |  | 247
 |  |  | 67110 |  |  | monthly | ICF/MR |  | 4793 |  | 349
 |  |  | 67120 |  |  | monthly | ICF/MR |  | 3638 |  | 248
 |  |  | 67140 |  |  | monthly | ICF/MR |  | 6046 |  | 1356
 |  |  | 67150 |  |  | monthly | ICF/MR |  | 4627 |  | 171
 |  |  | 68200 |  |  | monthly | CLA |  | 9082 |  | 1204
 |  |  | 68210 |  |  | monthly | ICF/MR |  | 4624 |  | 749
 |  |  | 68300 |  |  | monthly | ICF/MR |  | 7071 |  | 1135
 |  |  | 68320 |  |  | monthly | ICF/MR |  | 9477 |  | 389
 |  |  | 68500 |  |  | monthly | ICF/MR |  | 9474 |  | 1398
 |  |  | 91100 |  |  | monthly | ICF/MR |  | 2334 |  | 1460
 |  |  | 79000 |  |  | monthly | ICF/MR |  | 848 |  | 1188
 | Totals: