Spreadsheet: 851469d1701704389-how-do-i-write-a-formula-that-looks-at-month-year-amount-and-excludes-specific-items-filters-example_12-4-23
Sheet: Prop&Equip-Maint. Mortgage

 | (Mortgage) , (Property) , (Equip.) , Taxes          YEAR - |  |  |  | 2023 |  |  |  | YEAR TO DATE TOTALS |  |  | CURRENT MONTH TOTALS |  |  |  |  |  |  |  |  |  | Property Tax
 | Choose Month Below |  |  | YEAR TO DATE  ----> | 6100.280000000002 |  |  |  | House Property Taxes (Only) | 1200.9 |  | House Property Taxes | 240.18 | K2 | Spent By Category By Month |  |  | Spent By Category By Year |  |  |  | Total
 |  |  | 266.1600000000001 | <---- AMOUNT LESS MORTGAGE                                 MONTHLY AVERAGE  ----> | 508.3566666666668 |  |  |  | Prop & Maint (Only) | 0 |  | Prop & Maint | 0 | K3 | Select Category : | Equipment Maintenance |  | Select Category : | Equipment Maintenance |  |  | 0
 |  |  |  | CURRENT MONTH  ----> | 1069.16 |  |  |  | MORTGAGE PMT'S | 4015 |  | MORTGAGE PMT'S | 803 | K4 | Select Month : | April |  | Amount Spent Over The Year -- >> | Total Year | Paid |  | 1331.16 | all together for G10 & Lot-15 Year To Date.
 | 2023-05-01 00:00:00 | <-------------------------------------------------------------- Amount Spent During Selected Month ----------------------------------------------------> |  |  | 1069.16 |  |  |  | Equipment Maintenance | 286.39 |  | Equipment Maintenance | 0 | K5 | Total Amount : | #[NAME]! |  | Total Amount : | #[NAME]! |  |  | 0
 | DATE | Vendor | Category | Description or  Used For ? | AMOUNT |  |  |  | Lot 15 Property Taxes (Only) | 130.26 |  | Lot 15 Property Taxes | 0
 | 2023-01-01 00:00:00 | Wellsfargo | Mortgage | Mortgage Pmt (P&I) Incl. | 803 |  | Classification |  | Category Table | 2022-01-01 00:00:00
 | 2023-01-01 00:00:00 | Taxes (House) | Property Tax | Tax on 160 High Ridge | 193.16 |  | Property Maintenance |  | Select | 2023-01-01 00:00:00 |  |  |  |  | DESC. DROP DOPWN LIST |  | MONTHS
 | 2023-01-07 00:00:00 | Amazon | Equipment Maintenance | Wheels & (2) Pulleys for Shop Press  Amazon | 57.18 |  | Equipment Maintenance |  | Home Depot | 2024-01-01 00:00:00 |  |  |  |  | Choose from list |  | January
 | 2023-01-09 00:00:00 | Amazon | Equipment Maintenance | Pulleys for Shop Press (Needed 2 more to complete the job)  Amazon | 27.51 |  | Property Tax |  | Lowes | 2025-01-01 00:00:00 |  |  |  |  | Home Depot |  | February
 | 2023-01-16 00:00:00 | [NAME]. Vendor | Equipment Maintenance | Eye Bolts - Cable Clamps  Tractor Supply | 30.52 |  | Mortgage |  | [NAME] | 2026-01-01 00:00:00 |  |  |  |  | Lowes |  | March
 | 2023-01-18 00:00:00 | Walmart | [NAME] | Drano (For the bathtub)  Walmart | 19.32 |  | Tools |  | Courtland Hardware | 2027-01-01 00:00:00 |  |  |  |  | [NAME] |  | April
 | 2023-01-19 00:00:00 | Amazon | Tools | Hand Snake for Drain Cleaning  Amazon | 59.55 |  | [NAME]. Parts |  | Amazon | 2028-01-01 00:00:00 |  |  |  |  | Courtland HDW |  | May
 | 2023-01-23 00:00:00 | [NAME]. Vendor | Equipment Maintenance | 12" of 1"x6" Flat Bar & 12" of 3/8"x 6" Flat Bar (For Press)  Metal Markets | 82.13 |  | [NAME] |  | Tractor Supply | 2029-01-01 00:00:00 |  |  |  |  | Amazon |  | June
 | 2023-01-25 00:00:00 | Home Depot | Equipment Maintenance | (4) [NAME] (for Press)  Home Depot | 5.3 |  | Steel Purchase's |  | The [NAME] | 2030-01-01 00:00:00 |  |  |  |  | Tractor Supply |  | July
 | 2023-01-25 00:00:00 | [NAME]. Vendor | Equipment Maintenance | (4) 7/16 x 7 1/2" Bolts (For Press)  A&A Bolt | 29.05 |  | Grease - Oil - Lube |  | PAY-PAL | 2031-01-01 00:00:00 |  | YEAR TO DATE (Less Ins Pmts) |  |  | TRACTOR SUPPLY |  | August