Spreadsheet: 115034d1310664199-how-to-add-additional-criteria-to-a-sumif-formual-dummy
Sheet: Commercial Loans

Process date: 6.3.11
System | Officer Name | ARMS Identifier | Bank # | Account Number | Customer Name | Current Balance | DPD | Maturity Date | Collector Assigned | Pending Loan Action | Follow up date | Date last comment | Collection Comments | Taxes/Insurance | Contact Person | 3 Day Ltr | 15 Day Ltr | 30 Day Ltr | Home Phone | Business Phone | Past due payments | PD Interval | PD Date | Participation | GL Desc H02 | Consumer/ Small Business | Description | Status | Non-Accrual Date | CC # | CC Name | LOB | Off # | SS # | Region | Matured Flag
 |  |  |  |  |  | 111336.22 | 17 | 2014-10-25 00:00:00 | AL |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-26 00:00:00
 |  |  |  |  |  | 44737.42 | 9 | 2013-05-03 00:00:00 | Iris/AL |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-04 00:00:00
 |  |  |  |  |  | 42654.22 | 88 | 2012-02-15 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 3 | 61-90 | 2011-04-16 00:00:00
 |  |  |  |  |  | 80370.73 | 537 | 2010-06-21 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 6 | 121+ | 2010-01-22 00:00:00
 |  |  |  |  |  | 34159.1 | 39 | 2013-07-03 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-06-04 00:00:00
 |  |  |  |  |  | 46513.59 | 10 | 2016-03-02 00:00:00 | Nydia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-03 00:00:00
 |  |  |  |  |  | 41206.89 | 12 | 2013-11-30 00:00:00 | Olivia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-01 00:00:00
 |  |  |  |  |  | 10855.64 | 22 | 2013-04-20 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-21 00:00:00
 |  |  |  |  |  | 52602.37 | 11 | 2012-12-01 00:00:00 | Sonia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-02 00:00:00
 |  |  |  |  |  | 26283.12 | 28 | 2013-04-14 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-15 00:00:00
 |  |  |  |  |  | 237361.71 | 177 | 2023-01-16 00:00:00 | Thelma |  |  |  |  |  |  |  |  |  |  |  | 6 | 121+ | 2011-01-17 00:00:00
 |  |  |  |  |  | 110973.86 | 25 | 2014-12-18 00:00:00 | Yolo |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-18 00:00:00
 |  |  |  |  |  | 54327.2 | 216 | 2019-06-08 00:00:00 | OFF |  |  |  |  |  |  |  |  |  |  |  | 8 | 121+ | 2010-12-09 00:00:00
 |  |  |  |  |  | 39503.39 | 27 | 2012-06-15 00:00:00 | Yolo/OFF |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-16 00:00:00
 |  |  |  |  |  | 1001142.32 | 106 | 2012-04-28 00:00:00 | ARMS |  |  |  |  |  |  |  |  |  |  |  | 4 | 91-120 | 2011-03-29 00:00:00
 |  |  |  |  |  | 938349.23 | 275 | 2010-10-10 00:00:00 | TBD |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-10-11 00:00:00
 |  |  |  |  |  | 11115.86 | 37 | 2013-06-05 00:00:00 | Part |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-06-06 00:00:00
 |  |  |  |  |  | 2648.29 | 47 | 2011-06-26 00:00:00 | AL |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-05-27 00:00:00
 |  |  |  |  |  | 223782.27 | 24 | 2016-01-18 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-19 00:00:00
 |  |  |  |  |  | 116856.02 | 41 | 2011-06-01 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 31-60 | 2011-06-02 00:00:00
 |  |  |  |  |  | 1491.06 | 35 | 2011-11-07 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-06-08 00:00:00
 |  |  |  |  |  | 19549.52 | 12 | 2013-08-30 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-01 00:00:00
 |  |  |  |  |  | 11662.75 | 14 | 2012-01-31 00:00:00 | Nydia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-29 00:00:00
 |  |  |  |  |  | 2734.96 | 14 | 2012-01-14 00:00:00 | Olivia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-29 00:00:00
 |  |  |  |  |  | 14256.44 | 22 | 2012-12-20 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-21 00:00:00
 |  |  |  |  |  | 72544.83 | 11 | 2013-06-01 00:00:00 | Sonia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-02 00:00:00
 |  |  |  |  |  | 9919.85 | 10 | 2012-12-02 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-03 00:00:00
 |  |  |  |  |  | 69422.47 | 40 | 2013-01-02 00:00:00 | Thelma |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-06-03 00:00:00
 |  |  |  |  |  | 8111.96 | 68 | 2012-05-05 00:00:00 | Yolo |  |  |  |  |  |  |  |  |  |  |  | 3 | 61-90 | 2011-05-06 00:00:00
 |  |  |  |  |  | 19569.83 | 4 | 2012-09-08 00:00:00 | OFF |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-09 00:00:00
 |  |  |  |  |  | 170706.11 | 83 | 2020-09-20 00:00:00 | Yolo/OFF |  |  |  |  |  |  |  |  |  |  |  | 3 | 61-90 | 2011-04-21 00:00:00
 |  |  |  |  |  | 13558.68 | 27 | 2008-09-18 00:00:00 | ARMS |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-16 00:00:00
 |  |  |  |  |  | 83913.67 | 269 | 2015-02-16 00:00:00 | TBD |  |  |  |  |  |  |  |  |  |  |  | 9 | 121+ | 2010-10-17 00:00:00
 |  |  |  |  |  | 155099.24 | 602 | 2012-08-17 00:00:00 | Part |  |  |  |  |  |  |  |  |  |  |  | 20 | 121+ | 2009-11-18 00:00:00
 |  |  |  |  |  | 133006.32 | 541 | 2012-08-17 00:00:00 | AL |  |  |  |  |  |  |  |  |  |  |  | 18 | 121+ | 2010-01-18 00:00:00
 |  |  |  |  |  | 313191.34 | 637 | 2009-10-13 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2009-10-14 00:00:00
 |  |  |  |  |  | 549029.24 | 735 | 2009-11-07 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 5 | 121+ | 2009-07-08 00:00:00
 |  |  |  |  |  | 56040.91 | 15 | 2015-07-27 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-28 00:00:00
 |  |  |  |  |  | 100000 | 14 | 2008-10-01 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-29 00:00:00
 |  |  |  |  |  | 156916.04 | 94 | 2012-04-09 00:00:00 | Nydia |  |  |  |  |  |  |  |  |  |  |  | 1 | 91-120 | 2011-04-10 00:00:00
 |  |  |  |  |  | 13012.03 | 12 | 2013-11-30 00:00:00 | Olivia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-01 00:00:00
 |  |  |  |  |  | 96761.86 | 504 | 2017-08-23 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 17 | 121+ | 2010-02-24 00:00:00
 |  |  |  |  |  | 316197.79 | 979 | 2018-01-05 00:00:00 | Sonia |  |  |  |  |  |  |  |  |  |  |  | 36 | 121+ | 2008-11-06 00:00:00
 |  |  |  |  |  | 159822.42 | 377 | 2010-09-30 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 4 | 121+ | 2010-07-01 00:00:00
 |  |  |  |  |  | 498972.89 | 579 | 2009-12-10 00:00:00 | Thelma |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2009-12-11 00:00:00
 |  |  |  |  |  | 1414499.22 | 625 | 2011-11-10 00:00:00 | Yolo |  |  |  |  |  |  |  |  |  |  |  | 21 | 121+ | 2009-10-26 00:00:00
 |  |  |  |  |  | 34690.32 | 393 | 2011-06-14 00:00:00 | OFF |  |  |  |  |  |  |  |  |  |  |  | 13 | 121+ | 2010-06-15 00:00:00
 |  |  |  |  |  | 63234.73 | 15 | 2012-07-27 00:00:00 | Yolo/OFF |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-28 00:00:00
 |  |  |  |  |  | 20114.69 | 15 | 2012-07-27 00:00:00 | ARMS |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-28 00:00:00
 |  |  |  |  |  | 335208.16 | 26 | 2037-11-16 00:00:00 | TBD |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-06-17 00:00:00
 |  |  |  |  |  | 99938.38 | 38 | 2026-08-04 00:00:00 | Part |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-06-05 00:00:00
 |  |  |  |  |  | 95475.34 | 453 | 2010-04-15 00:00:00 | AL |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-04-16 00:00:00
 |  |  |  |  |  | 88532.96 | 35 | 2022-07-07 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-06-08 00:00:00
 |  |  |  |  |  | 113351.52 | 676 | 2010-10-04 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 14 | 121+ | 2009-09-05 00:00:00
 |  |  |  |  |  | 27214.12 | 800 | 2009-05-03 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2009-05-04 00:00:00
 |  |  |  |  |  | 157252.27 | 110 | 2012-10-24 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 4 | 91-120 | 2011-03-25 00:00:00
 |  |  |  |  |  | 240000 | 554 | 2010-09-04 00:00:00 | Nydia |  |  |  |  |  |  |  |  |  |  |  | 9 | 121+ | 2010-01-05 00:00:00
 |  |  |  |  |  | 5131.39 | 5 | 2014-05-07 00:00:00 | Olivia |  |  |  |  |  |  |  |  |  |  |  | 1 | 3-30 | 2011-07-08 00:00:00
 |  |  |  |  |  | 63558.63 | 472 | 2010-03-27 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-03-28 00:00:00
 |  |  |  |  |  | 254640.35 | 38 | 2026-01-03 00:00:00 | Sonia |  |  |  |  |  |  |  |  |  |  |  | 2 | 31-60 | 2011-06-05 00:00:00
 |  |  |  |  |  | 73719.44 | 877 | 2012-05-15 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 29 | 121+ | 2009-02-16 00:00:00
 |  |  |  |  |  | 23476.52 | 119 | 2008-09-18 00:00:00 | Thelma |  |  |  |  |  |  |  |  |  |  |  | 4 | 91-120 | 2011-03-16 00:00:00
 |  |  |  |  |  | 19254.79 | 122 | 2008-08-15 00:00:00 | Yolo |  |  |  |  |  |  |  |  |  |  |  | 3 | 121+ | 2011-03-13 00:00:00
 |  |  |  |  |  | 30704.3 | 122 | 2008-08-15 00:00:00 | OFF |  |  |  |  |  |  |  |  |  |  |  | 3 | 121+ | 2011-03-13 00:00:00
 |  |  |  |  |  | 22660.44 | 105 | 2010-02-02 00:00:00 | Yolo |  |  |  |  |  |  |  |  |  |  |  | 20 | 91-120 | 2011-03-30 00:00:00
 |  |  |  |  |  | 18065.83 | 518 | 2010-02-09 00:00:00 | ARMS |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-02-10 00:00:00
 |  |  |  |  |  | 18678.32 | 518 | 2010-02-09 00:00:00 | TBD |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-02-10 00:00:00
 |  |  |  |  |  | 30399.98 | 516 | 2010-02-11 00:00:00 | Part |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-02-12 00:00:00
 |  |  |  |  |  | 23750.06 | 133 | 2010-04-04 00:00:00 | AL |  |  |  |  |  |  |  |  |  |  |  | 23 | 121+ | 2011-03-02 00:00:00
 |  |  |  |  |  | 39462.9 | 125 | 2010-04-12 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 23 | 121+ | 2011-03-10 00:00:00
 |  |  |  |  |  | 15651.4 | 953 | 2010-04-01 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 17 | 121+ | 2008-12-02 00:00:00
 |  |  |  |  |  | 17731.15 | 391 | 2010-06-16 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-06-17 00:00:00
 |  |  |  |  |  | 34204.6 | 135 | 2008-08-02 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 3 | 121+ | 2011-02-28 00:00:00
 |  |  |  |  |  | 7815.83 | 135 | 2008-08-02 00:00:00 | Nydia |  |  |  |  |  |  |  |  |  |  |  | 3 | 121+ | 2011-02-28 00:00:00
 |  |  |  |  |  | 37990.84 | 135 | 2008-08-02 00:00:00 | Olivia |  |  |  |  |  |  |  |  |  |  |  | 3 | 121+ | 2011-02-28 00:00:00
 |  |  |  |  |  | 19744.02 | 110 | 2010-07-27 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 26 | 91-120 | 2011-03-25 00:00:00
 |  |  |  |  |  | 19758.04 | 110 | 2010-07-27 00:00:00 | Sonia |  |  |  |  |  |  |  |  |  |  |  | 26 | 91-120 | 2011-03-25 00:00:00
 |  |  |  |  |  | 18138.21 | 757 | 2010-09-15 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 16 | 121+ | 2009-06-16 00:00:00
 |  |  |  |  |  | 21969.59 | 107 | 2010-09-30 00:00:00 | Thelma |  |  |  |  |  |  |  |  |  |  |  | 28 | 91-120 | 2011-03-28 00:00:00
 |  |  |  |  |  | 14808.52 | 134 | 2010-09-03 00:00:00 | Yolo |  |  |  |  |  |  |  |  |  |  |  | 28 | 121+ | 2011-03-01 00:00:00
 |  |  |  |  |  | 19168.56 | 291 | 2010-10-24 00:00:00 | OFF |  |  |  |  |  |  |  |  |  |  |  | 2 | 121+ | 2010-09-25 00:00:00
 |  |  |  |  |  | 18567.66 | 253 | 2010-11-01 00:00:00 | Yolo/OFF |  |  |  |  |  |  |  |  |  |  |  | 1 | 121+ | 2010-11-02 00:00:00
 |  |  |  |  |  | 67263.73 | 121 | 2008-11-16 00:00:00 | ARMS |  |  |  |  |  |  |  |  |  |  |  | 6 | 121+ | 2011-03-14 00:00:00
 |  |  |  |  |  | 21064.45 | 129 | 2010-12-08 00:00:00 | TBD |  |  |  |  |  |  |  |  |  |  |  | 31 | 121+ | 2011-03-06 00:00:00
 |  |  |  |  |  | 21200.67 | 129 | 2010-12-08 00:00:00 | Part |  |  |  |  |  |  |  |  |  |  |  | 31 | 121+ | 2011-03-06 00:00:00
 |  |  |  |  |  | 22083.07 | 128 | 2010-12-09 00:00:00 | AL |  |  |  |  |  |  |  |  |  |  |  | 31 | 121+ | 2011-03-07 00:00:00
 |  |  |  |  |  | 28639.71 | 116 | 2008-12-21 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 8 | 91-120 | 2011-03-19 00:00:00
 |  |  |  |  |  | 24753.23 | 108 | 2008-12-29 00:00:00 | [NAME]/off |  |  |  |  |  |  |  |  |  |  |  | 7 | 91-120 | 2011-03-27 00:00:00
 |  |  |  |  |  | 23515.73 | 32 | 2011-02-13 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 30 | 31-60 | 2011-06-11 00:00:00
 |  |  |  |  |  | 20810.24 | 124 | 2011-02-13 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 33 | 121+ | 2011-03-11 00:00:00
 |  |  |  |  |  | 19538.56 | 120 | 2011-02-17 00:00:00 | Nydia |  |  |  |  |  |  |  |  |  |  |  | 33 | 91-120 | 2011-03-15 00:00:00
 |  |  |  |  |  | 12350.55 | 660 | 2011-03-20 00:00:00 | Olivia |  |  |  |  |  |  |  |  |  |  |  | 19 | 121+ | 2009-09-21 00:00:00
 |  |  |  |  |  | 20344.04 | 117 | 2011-03-20 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 34 | 91-120 | 2011-03-18 00:00:00
 |  |  |  |  |  | 25372.83 | 107 | 2011-03-31 00:00:00 | Sonia |  |  |  |  |  |  |  |  |  |  |  | 34 | 91-120 | 2011-03-28 00:00:00
 |  |  |  |  |  | 12994.59 | 223 | 2011-04-01 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 5 | 121+ | 2010-12-02 00:00:00
 |  |  |  |  |  | 21487.37 | 131 | 2011-04-06 00:00:00 | Thelma |  |  |  |  |  |  |  |  |  |  |  | 35 | 121+ | 2011-03-04 00:00:00
 |  |  |  |  |  | 18989.34 | 799 | 2011-04-04 00:00:00 | Yolo |  |  |  |  |  |  |  |  |  |  |  | 24 | 121+ | 2009-05-05 00:00:00
 |  |  |  |  |  | 20017.13 | 103 | 2011-03-31 00:00:00 | OFF |  |  |  |  |  |  |  |  |  |  |  | 1 | 91-120 | 2011-04-01 00:00:00