Spreadsheet: 164355d1340732547-using-sumifs-how-to-create-criteria-to-include-if-cell-doesnt-match-specific-data-12-13-budget-test
Sheet: Overview

 |  |  | 11000 - 301010 |  |  |  |  | 11000 - 301020 |  |  |  |  | 11000 - 301030 |  |  |  |  | 17800 - 301010
 | Accounts | Program Code | Adopted  Budget | Expended | Transfers | Adjusted  Balance |  | Adopted Budget | Expended | Transfers | Adjusted Budget |  | Adopted Budget | Expended | Transfers | Adjusted Budget |  | Adopted Budget | Expended | Transfers | Adjusted Budget
 | 231000 | 000000 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 |  | 601000 | 12082
 |  | Other | 0
0 | 241000 | 000000 | 43328 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 |  | 601000 | 0
 |  | Other | 0
 | 431000 | 000000 | 0 |  |  |  |  | 2400 |  |  |  |  | 0 |  |  |  |  | 24353
 |  | 601000 | 8000
 |  | Other | 0
 | 433000 | 000000 | 0 |  |  |  |  | 4462 |  |  |  |  | 0 |  |  |  |  | 0
 |  | 601000 | 0
 |  | Other | 0
 | 441000 | 000000 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 4235
 |  | 601000 | 0
 |  | Other | 0
 | 451000 |  | 15802 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 471000 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 521000 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 522000 |  | 0 |  |  |  |  | 2994 |  |  |  |  | 4677 |  |  |  |  | 0
0 | 525000 |  | 19200 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 531000 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 554500 |  | 0 |  |  |  |  | 150 |  |  |  |  | 0 |  |  |  |  | 0
 | 564000 |  | 2211 |  |  |  |  | 1570 |  |  |  |  | 0 |  |  |  |  | 0
 | 564500 |  | 0 |  |  |  |  | 0 |  |  |  |  | 8236 |  |  |  |  | 0
 | 580000 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 581000 |  | 0 |  |  |  |  | 0 |  |  |  |  | 1593 |  |  |  |  | 0
 | 589000 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 589010 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 641200 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 641300 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 641400 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 641500 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 641600 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 641700 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 642200 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 642300 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 642400 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 642500 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 642600 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 642700 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 643200 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 643300 |  | 1035 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 643400 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 643500 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 643600 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 643700 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 644200 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 644300 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 644400 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 645200 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 645300 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 645300 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | 645400 |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0