Spreadsheet: 842324d1694437229-adding-cells-and-columns-with-criteria-of-other-columns-formula-test
Sheet: Sheet1

 | Detailed Activity |  |  |  |  |  |  |  |  | Outstanding | Current | Actual |  | Cash on Hand
 | Date | Debit / Credit | # | Name | Amount $ | Cleared |  |  | Daily Reconciliaton
 |  |  |  |  |  |  |  |  | Date | Payed Out $ | In Person Payment | Online Payment | Cash Payment | Donations | Total | Reconciliation | Difference
 | 2023-09-01 00:00:00 | Credit | 115697 | JJ | 145 | False
 | 2023-09-01 00:00:00 | Debit | 127834 | SA | 122 | False |  |  |  |  | 1500
 | 2023-09-01 00:00:00 | Debit | 39476 | BN | 32 | False |  |  |  |  | 1250
 | 2023-09-02 00:00:00 | Debit | 43239 | RB | 12 | False |  |  |  |  | 2250
 | 2023-09-03 00:00:00 | Debit | 138871 | JJ | 98 | False |  |  |  |  | 2000
 | 2023-09-03 00:00:00 | Debit | 47894 | SC | 12 | False |  |  |  |  | 1300
 | 2023-09-04 00:00:00 | Debit | 48919 | SC | 45 | False |  |  |  |  | 2250
 | 2023-09-04 00:00:00 | Credit | 139777 | TT | 250 | False |  |  |  |  | 3250
 | 2023-09-04 00:00:00 | Debit | 140110 | JJ | 125 | False |  |  | Weekly Totals
 | 2023-09-05 00:00:00 | Debit | 142911 | AB | 150 | False
 | 2023-09-05 00:00:00 | Debit | 50078 | BN | 35 | False
 | 2023-09-06 00:00:00 | Debit | 52289 | RB | 50 | False
 | 2023-09-06 00:00:00 | Debit | 148364 | FT | 250 | False
 | 2023-09-06 00:00:00 | Debit | 52604 | SC | 21 | False
 | 2023-09-06 00:00:00 | Credit | 148991 | KY | 100 | False
 | 2023-09-07 00:00:00 | Debit | 149723 | OP | 100 | False
 | 2023-09-07 00:00:00 | Debit | 53001 | LL | 25 | False
 | 2023-09-09 00:00:00 | Debit | 53899 | LL | 35 | False
 | 2023-09-09 00:00:00 | Debit | 54301 | HT | 55 | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  |  |  |  |  | False
 |  | Credit
 |  | Debit