Spreadsheet: 881544d1729620121-revisiting-the-and-function-syntax-issue-test-file-02
Sheet: Sheet1

 | 2024-01-01 00:00:00 | QUICK CHECK | EXPENDITURES
 |  | ◊ Amt Spent By Selected  Category Based on Year Selected ◊ |  |  | Total   (Spent) Year to Date |  |  | Expenses!Z6 |  |  |  |  |  |  |  | Budget [NAME]
 |  | LOANS |  |  | Total (Spent in) Current Month
 | ⟩  Amt spent in selected Month  ⟨ |  |  |  | Deposits  This Month |  | IRA - 401K & Savings DEPOSITs |  |  |  |  |  |  |  |  | Choose  A Year | Choose A Category | Select A Type | CURRENT MONTH | PRIOR-YEAR MONTH | CURRENT YEAR TOTAL | PRIOR YEAR TOTAL | BUDGET STATUS
 | 2024-08-01 00:00:00 | <-----Select Month------> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] for  column S | [NAME] for  column T
LINE | DATE | SELECT  CATEGORY | SELECT  TYPE | SELECT  DESC.  SPECIFIC | *ADDITIONAL NOTES* | Amt's |  |  |  |  |  |  |  | Go To Home |  | 2024-10-01 00:00:00 | DEPOSIT | Checking Acct |  |  |  |  |  |  | CLOTHING | Checking Acct
1 | 2024-10-22 00:00:00 | DEPOSIT | Checking Acct |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEPOSIT | Savings Acct
 | 2024-10-22 00:00:00 | DEPOSIT | Savings Acct |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DINING | IRA Acct
 | 2024-10-22 00:00:00 | DEPOSIT | IRA Acct |  |  |  | 100 |  |  |  |  |  |  |  | FORMULAS WRITTEN IN TEXT ONLY |  |  |  |  |  |  |  |  |  | ENTERTAINMENT | 401K Acct
 | 2024-10-22 00:00:00 | DEPOSIT | 401K Acct |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQUIPMENT | Tax Refund (Fed)
 | 2024-10-22 00:00:00 | DEPOSIT | Tax Refund (Fed) |  |  | 1000 |  |  |  |  |  |  |  |  | T6 | SUMPRODUCT(AND(($G$7:$G$16,$H$7:$H$16)*($C$7:$C$16=$R$6,$D$7:$D$16=$S$6)*(MONTH($B$7:$B$16)=MONTH(NOW())*(YEAR($B$7:$B$16)=YEAR($Q$6))))) |  |  |  |  |  |  |  |  | FUEL | Social Security
 | 2024-10-22 00:00:00 | DEPOSIT | Social Security |  |  | 2000 |  |  |  |  |  |  |  |  | U6 | SUMPRODUCT(AND(($G$7:$G$16,$H$7:$H$16)*($C$7:$C$16=$R$6,$D$7:$D$16)*(MONTH($B$7:$B$16)=MONTH(NOW())*(YEAR($B$7:$B$16)=YEAR($Q$6)-1)))) |  |  |  |  |  |  |  |  | HEALTH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V6 | SUMPRODUCT(AND(($G$7:$G$16,$H$7:$H$16)*($C$7:$C$16=$R$6)*(YEAR($B$7:$B$16)=YEAR($Q$6)))) |  |  |  |  |  |  |  |  | INSURANCE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W6 | SUMPRODUCT(AND(($G$7:$G$16,$H$7:$H$16)*($C$7:$C$16=$R$6)*(YEAR($B$7:$B$16)=YEAR($Q$6)-1))) |  |  |  |  |  |  |  |  | LOANS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAINT_REPAIR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLANTS
 | NOTE: |  |  | Deposits → | Monthly [NAME]  (Deposits Only) →  →  →  → |  |  | [NAME]CURRENT MONTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UTILITIES
 |  |  |  |  | Yearly Quick Check (Deposits Only) →  →  →  → |  |  | [NAME]CURRENT YEAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VEHICLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROCERIES
 |  |  |  | AMOUNTS SPENT→ | Monthly [NAME]  (Doest not include Deposits) →  →  →  →
 |  |  |  |  | Yearly Quick Check (Does not include Deposits) →  →  →  →