Spreadsheet: 873523d1720015919-error-catching-not-working-the-way-i-want-it-to-sample-jomili-
Sheet: GEFCU

 |  |  |  |  |  |  | Error Catching not working the way I want it to. (excelforum.com)
 | Funds in Account
Account | Entered | Banked | Available (Entered minus [NAME])
Checking
Savings
SWIS MM
Grand Total
Account | Entered | Banked | Amount | Name/Reason
Checking | 2023-10-23 00:00:00 | 2023-10-23 00:00:00 | 343 | Retirement
Checking | 2023-10-27 00:00:00 | 2023-10-30 00:00:00 | -1225.38 | Credit Card
Checking | 2023-10-30 00:00:00 | 2023-10-30 00:00:00 | 2390.77 | Retirement
Checking | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 125.8 | MetLife
Checking | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | -35.75 | MetLife
Checking | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | -1697.64 | Allstate
Checking | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | -92.3 | House
Checking | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | -2 | Misc
Checking | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 0.94 | Dividend
Savings | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 450.27 | Misc
Savings | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 432.7 | Retirement
SWIS MM | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 185.17 | Dividend
Checking | 2023-11-01 00:00:00 | 2023-11-01 00:00:00 | -148.17 | MetLife
Checking | 2023-11-03 00:00:00 | 2023-11-03 00:00:00 | -33.55 | Insurance
Checking | 2023-11-06 00:00:00 | 2023-11-15 00:00:00 | -90 | House
Checking | 2023-11-06 00:00:00 | 2023-11-07 00:00:00 | -194.43 | Credit Card
Checking | 2023-11-06 00:00:00 | 2023-11-07 00:00:00 | -43.66 | Retirement
Checking | 2023-11-06 00:00:00 | 2023-11-06 00:00:00 | -3195 | House
Checking | 2023-11-13 00:00:00 | 2023-11-13 00:00:00 | 204.66 | Misc
Savings | 2023-11-13 00:00:00 | 2023-11-13 00:00:00 | 331.39 | Misc
Checking | 2023-11-20 00:00:00 | 2023-11-20 00:00:00 | 343 | Retirement
Checking | 2023-11-21 00:00:00 | 2023-11-21 00:00:00 | -200 | Choice
Checking | 2023-11-25 00:00:00 | 2023-11-28 00:00:00 | -93.92 | COA
Checking | 2023-11-27 00:00:00 | 2023-11-28 00:00:00 | -211.91 | Misc
Checking | 2023-11-28 00:00:00 | 2023-11-28 00:00:00 | -47.57 | House
Checking | 2023-11-29 00:00:00 | 2023-11-29 00:00:00 | 2390.77 | Retirement
Checking | 2023-11-29 00:00:00 | 2023-11-29 00:00:00 | -35.75 | MetLife
Checking | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 125.8 | MetLife
Checking | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 0.36 | Dividend
Checking | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | -2 | Misc
Savings | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 66.95 | Misc
Savings | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 432.7 | Retirement
Savings | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 450.27 | Misc
SWIS MM | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 198.22 | Dividend
Checking | 2023-12-01 00:00:00 | 2023-12-01 00:00:00 | -148.17 | MetLife
Checking | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | -43.66 | Retirement
Checking | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | -1561.68 | Credit Card
Checking | 2023-12-04 00:00:00 | 2023-12-04 00:00:00 | 3500 | Misc
Savings | 2023-12-04 00:00:00 | 2023-12-04 00:00:00 | 3500 | Misc
Checking | 2023-12-05 00:00:00 | 2023-12-05 00:00:00 | -3450 | House
Checking | 2023-12-05 00:00:00 | 2023-12-05 00:00:00 | -33.55 | Insurance
Checking | 2023-12-07 00:00:00 | 2023-12-08 00:00:00 | -200.93 | Credit Card
Checking | 2023-12-14 00:00:00 | 2023-12-15 00:00:00 | 47.84 | MetLife
Savings | 2023-12-14 00:00:00 | 2023-12-14 00:00:00 | 5.2 | MetLife
Savings | 2023-12-14 00:00:00 | 2023-12-14 00:00:00 | 37.44 | MetLife
Checking | 2023-12-15 00:00:00 | 2023-12-28 00:00:00 | -74.36 | COA
Checking | 2023-12-18 00:00:00 | 2023-12-19 00:00:00 | -200 | Choice
Checking | 2023-12-22 00:00:00 | 2023-12-22 00:00:00 | 343 | Retirement
Checking | 2023-12-28 00:00:00 | 2023-12-28 00:00:00 | 2480.67 | Retirement
Checking | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 128.32 | MetLife
Checking | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | -35.75 | MetLife
Savings | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 441.35 | Retirement
Savings | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 450.27 | Misc
Checking | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 0.41 | Dividend
Checking | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | -2 | Misc
Savings | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 62.96 | Dividend
SWIS MM | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 205 | Dividend
Checking | 2024-01-02 00:00:00 | 2024-01-08 00:00:00 | -48.77 | House
Checking | 2024-01-02 00:00:00 | 2024-01-08 00:00:00 | -1853.4 | Credit Card
Checking | 2024-01-02 00:00:00 | 2024-01-02 00:00:00 | -185.21 | MetLife
Checking | 2024-01-02 00:00:00 | 2024-01-02 00:00:00 | 3000 | Misc
Savings | 2024-01-02 00:00:00 | 2024-01-02 00:00:00 | 3000 | Misc
Checking | 2024-01-03 00:00:00 | 2024-01-10 00:00:00 | -43.66 | Retirement
Checking | 2024-01-04 00:00:00 | 2024-01-04 00:00:00 | -33.55 | Insurance
Checking | 2024-01-05 00:00:00 | 2024-01-05 00:00:00 | -3450 | House
Checking | 2024-01-12 00:00:00 | 2024-01-16 00:00:00 | -6.72 | Credit Card
Checking | 2024-01-18 00:00:00 | 2024-02-18 00:00:00 | -32.37 | House
Checking | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | -200 | Choice
Checking | 2024-01-22 00:00:00 | 2024-01-22 00:00:00 | 350 | Retirement
Checking | 2024-01-30 00:00:00 | 2024-01-30 00:00:00 | 2476.3 | Retirement
Checking | 2024-01-30 00:00:00 | 2024-01-30 00:00:00 | -35.75 | MetLife
Checking | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 128.32 | MetLife
Checking | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 0.45 | Dividend
Checking | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | -2 | Misc
Savings | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 441.35 | Retirement
Savings | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 450.27 | Misc
SWIS MM | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 205.19 | Dividend
Checking | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 | -185.21 | MetLife
Checking | 2024-02-02 00:00:00 | 2024-02-02 00:00:00 | -1378.64 | Credit Card
Checking | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | -3450 | House
Checking | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | -33.55 | Insurance
Checking | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | -473.97 | Misc
Checking | 2024-02-06 00:00:00 | 2024-02-06 00:00:00 | -19.94 | Misc
Checking | 2024-02-06 00:00:00 | 2024-02-06 00:00:00 | 5000 | Misc
Savings | 2024-02-06 00:00:00 | 2024-02-06 00:00:00 | 5000 | Misc
Checking | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | -64.92 | Credit Card
Checking | 2024-02-13 00:00:00 | 2024-02-13 00:00:00 | -19.94 | Misc
Savings | 2024-02-13 00:00:00 | 2024-02-13 00:00:00 | 343.53 | Misc
Checking | 2024-02-21 00:00:00 | 2024-02-21 00:00:00 | -200 | Choice
Checking | 2024-02-21 00:00:00 | 2024-02-21 00:00:00 | 36.34 | COA
Checking | 2024-02-26 00:00:00 | 2024-02-26 00:00:00 | 350 | Retirement
Checking | 2024-02-28 00:00:00 | 2024-02-28 00:00:00 | 2476.3 | Retirement
Checking | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 128.32 | MetLife
Checking | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | -35.75 | MetLife
Checking | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 0.62 | Dividend
Checking | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | -2 | Misc
Savings | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 441.35 | Retirement
Savings | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 450.27 | Misc
SWIS MM | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 192.12 | Dividend
Checking | 2024-03-01 00:00:00 | 2024-03-01 00:00:00 | -185.21 | MetLife
Checking | 2024-03-04 00:00:00 | 2024-03-04 00:00:00 | -713.32 | Credit Card
Checking | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | -33.55 | Insurance
Checking | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | -3450 | House
Savings | 2024-03-07 00:00:00 | 2024-03-07 00:00:00 | 67.98 | Dividend
Checking | 2024-03-14 00:00:00 | 2024-03-14 00:00:00 | 47.84 | MetLife
Savings | 2024-03-14 00:00:00 | 2024-03-14 00:00:00 | 5.2 | MetLife
Savings | 2024-03-14 00:00:00 | 2024-03-14 00:00:00 | 37.44 | MetLife
Checking | 2024-03-15 00:00:00 | 2024-03-18 00:00:00 | -224.61 | Credit Card
Checking | 2024-03-19 00:00:00 | 2024-03-19 00:00:00 | -250 | Choice
Checking | 2024-03-25 00:00:00 | 2024-03-25 00:00:00 | 350 | Retirement
Checking | 2024-03-28 00:00:00 | 2024-03-28 00:00:00 | 2476.3 | Retirement
Checking | 2024-03-29 00:00:00 | 2024-03-29 00:00:00 | 128.32 | MetLife
Checking | 2024-03-29 00:00:00 | 2024-03-29 00:00:00 | -35.75 | MetLife
Savings | 2024-03-29 00:00:00 | 2024-03-29 00:00:00 | 441.35 | Retirement
Savings | 2024-03-29 00:00:00 | 2024-03-29 00:00:00 | 450.27 | Misc
Checking | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | 0.47 | Dividend
Checking | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | -2 | Misc
Savings | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | 58.35 | Dividend
SWIS MM | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | 205.54 | Dividend
Checking | 2024-04-01 00:00:00 | 2024-04-01 00:00:00 | 5000 | Misc
Checking | 2024-04-01 00:00:00 | 2024-04-01 00:00:00 | -185.21 | MetLife
Savings | 2024-04-01 00:00:00 | 2024-04-01 00:00:00 | 5000 | Misc
Checking | 2024-04-03 00:00:00 | 2024-04-03 00:00:00 | -3531.65 | Credit Card
Checking | 2024-04-03 00:00:00 | 2024-04-03 00:00:00 | -232.98 | Dr.
Checking | 2024-04-03 00:00:00 | 2024-04-03 00:00:00 | -33.55 | Insurance
Checking | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | -3450 | House
Checking | 2024-04-11 00:00:00 | 2024-04-11 00:00:00 | -157.82 | Misc
Checking | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | -944.89 | Credit Card
Checking | 2024-04-22 00:00:00 | 2024-04-22 00:00:00 | 350 | Retirement
Checking | 2024-04-22 00:00:00 | 2024-04-22 00:00:00 | -250 | Choice
Checking | 2024-04-29 00:00:00 | 2024-04-29 00:00:00 | 2476.3 | Retirement
Checking | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | 128.32 | MetLife
Checking | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | -35.75 | MetLife
Checking | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | 0.41 | Dividend
Checking | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | -2 | Misc
Savings | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | 441.35 | Retirement
Savings | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | 450.27 | Misc
SWIS MM | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | 199.09 | Dividend
Checking | 2024-05-01 00:00:00 | 2024-05-01 00:00:00 | -185.21 | MetLife
Checking | 2024-05-03 00:00:00 | 2024-05-06 00:00:00 | -848.89 | Credit Card
Checking | 2024-05-03 00:00:00 | 2024-05-03 00:00:00 | -33.55 | Insurance
Checking | 2024-05-03 00:00:00 | 2024-05-03 00:00:00 | 3000 | Misc
Savings | 2024-05-03 00:00:00 | 2024-05-03 00:00:00 | -3000 | Misc
Checking | 2024-05-06 00:00:00 | 2024-05-06 00:00:00 | -3450 | House
Checking | 2024-05-07 00:00:00 | 2024-05-20 00:00:00 | -330 | IRS
Checking | 2024-05-07 00:00:00 | 2024-05-15 00:00:00 | -1415 | IRS
Savings | 2024-05-14 00:00:00 | 2024-05-14 00:00:00 | 343.53 | Misc
Checking | 2024-05-19 00:00:00 | 2024-05-28 00:00:00 | -250 | Choice
Checking | 2024-05-20 00:00:00 | 2024-05-20 00:00:00 | 350 | Retirement
Checking | 2024-05-28 00:00:00 | 2024-06-06 00:00:00 | -243.3 | Credit Card
Checking | 2024-05-28 00:00:00 | 2024-05-28 00:00:00 | -3.95 | Misc
Checking | 2024-05-29 00:00:00 | 2024-05-29 00:00:00 | 3.95 | Misc
Savings | 2024-05-30 00:00:00 | 2024-05-30 00:00:00 | 450.27 | Retirement
Savings | 2024-05-30 00:00:00 | 2024-05-30 00:00:00 | 441.35 | Retirement
Checking | 2024-05-30 00:00:00 | 2024-05-30 00:00:00 | 2476.3 | Retirement
Checking | 2024-05-30 00:00:00 | 2024-05-30 00:00:00 | 128.32 | MetLife
Checking | 2024-05-31 00:00:00 | 2024-05-31 00:00:00 | -2 | Misc
Checking | 2024-05-31 00:00:00 | 2024-05-31 00:00:00 | 0.36 | Dividend
SWIS MM | 2024-05-31 00:00:00 | 2024-05-31 00:00:00 | 2005.9 | Dividend
Checking | 2024-06-03 00:00:00 | 2024-06-04 00:00:00 | -133 | Misc
Savings | 2024-06-03 00:00:00 | 2024-06-03 00:00:00 | 67.98 | Misc
Checking | 2024-06-03 00:00:00 | 2024-06-03 00:00:00 | 5000 | Misc
Savings | 2024-06-03 00:00:00 | 2024-06-03 00:00:00 | 5000 | Misc
Checking | 2024-06-03 00:00:00 | 2024-06-03 00:00:00 | -185.21 | MetLife
Checking | 2024-06-05 00:00:00 | 2024-06-05 00:00:00 | -3450 | House
Checking | 2024-06-05 00:00:00 | 2024-06-05 00:00:00 | -33.55 | Insurance
Checking | 2024-06-10 00:00:00 |  | -80.15 | IRS
Savings | 2024-06-11 00:00:00 |  | 39.24 | MetLife
Savings | 2024-06-11 00:00:00 |  | 5.45 | MetLife
Checking | 2024-06-11 00:00:00 |  | 50.14 | MetLife
Checking | 2024-06-16 00:00:00 |  | -250 | Choice
Checking | 2024-06-24 00:00:00 |  | 350 | Retirement
Checking | 2024-06-27 00:00:00 |  | 2476.3 | Retirement
Checking | 2024-06-28 00:00:00 | 2024-07-01 00:00:00 | -994.75 | Credit Card
Checking | 2024-06-28 00:00:00 |  | 128.32 | MetLife
Checking | 2024-06-28 00:00:00 |  | -85.62 | Dr.
Checking | 2024-06-30 00:00:00 |  | -2 | Misc
Checking | 2024-06-30 00:00:00 |  | 0.78 | Dividend
Checking | 2024-07-01 00:00:00 |  | -185.21 | MetLife
Checking | 2024-07-01 00:00:00 |  | -2