Spreadsheet: 848570d1699286147-request-help-in-correcting-a-formula-to-gather-data-and-subract-from-a-known-amount-exp-mortgage-compare-formula-problem-11-6-23
Sheet: Sheet1

 | (Mortgage) , (Property) , (Equip.) , Taxes          YEAR - |  |  |  | 2023-01-31 00:00:00 |  |  |  | YEAR TO DATE TOTALS |  |  | CURRENT MONTH TOTALS |  |  | Spent By Category By Month |  |  |  |  |  |  |  | Property Tax
 | Choose Month Below |  |  | YEAR TO DATE  ----> |  |  |  |  | House Property Taxes (Only) |  |  | House Property Taxes |  | K2 | Select Category : | Property Maintenance | Spent Year to Date |  |  | [NAME]. | AMT OVER SPENT |  | Total
 |  |  |  | <---- AVG MONTHLY LESS MORTGAGE                      MONTHLY AVERAGE  ----> |  |  |  |  | Prop & Maint (Only) |  |  | Prop & Maint |  | K3 | Select YEAR : | 2022-01-31 00:00:00 |  |  |  | 803
Budget # (Total) |  |  |  | CURRENT MONTH  ----> |  |  |  |  | MORTGAGE PMT'S |  |  | MORTGAGE PMT'S |  | K4 | Select Month : | 2023-04-01 00:00:00 |  |  |  |  |  | Paid |  | all together for G10 & Lot-15 Year To Date.
975 | 2023-10-01 00:00:00 | <-------------------------------------------------------------- Amount Spent During Selected Month ----------------------------------------------------> |  |  |  |  |  |  | Equipment Maintenance |  |  | Equipment Maintenance |  | K5 | Total Amount for Given Month :
 | DATE | Vendor | Category | Description or  Used For ? | AMOUNT |  |  |  | Lot 15 Property Taxes (Only) |  |  | Lot 15 Property Taxes
 | 2022-03-11 00:00:00 | Amazon | Equipment Maintenance | Item-2  (2-12VDC Digital Volt Mtr's)   $12.99 + tax | 13.77 |  | Classification |  | Category Table | 2022-01-31 00:00:00
 | 2022-03-11 00:00:00 | Amazon | Equipment Maintenance | Item-3  (Ampeak Trickle Chgr)   $23.19 + tax | 24.38 |  | Property Maintenance |  | Select | 2023-01-31 00:00:00 |  | PROPERTY TAX G10 | 2647.34 |  | DESC. DROP DOPWN LIST
 | 2022-04-01 00:00:00 | Taxes (Lot-15) | Property Tax | Lot 15 | 508.73 |  | Equipment Maintenance |  | Home Depot | 2024-01-31 00:00:00 |  | HOMEOWNER INS | 1255 |  | Choose from list
 | 2022-04-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for Apr | 790.06 |  | Property Tax |  | Lowes | 2025-01-31 00:00:00 |  | TAX & INS COST YLY |  |  | Home Depot
 | 2023-01-01 00:00:00 | Wellsfargo | Mortgage | Mortgage Pmt for Jan (P&I) Incl. | 803 |  | Mortgage |  | [NAME] | 2026-01-31 00:00:00 |  | TAX & INS COST MHY |  |  | Lowes
 | 2023-01-01 00:00:00 | Taxes (House) | Property Tax | Tax on 160 High Ridge | 193.16 |  | Tools |  | Courtland Hardware | 2027-01-31 00:00:00 |  | MORTGAGE PMT P&I | 505.26 |  | [NAME]
 | 2023-02-01 00:00:00 | Wellsfargo | Mortgage | Mortgage Pmt for Feb  (P&I) Incl. Actually PD 0n 1-27-23 | 803 |  | [NAME]. Parts |  | Amazon | 2028-01-31 00:00:00 |  | MORTGAGE PMT'S MADE | 803 |  | Courtland HDW
 | 2023-03-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for March | 803 |  | [NAME] |  | Tractor Supply | 2029-01-31 00:00:00 |  | MORTGAGE  SHORT COMINGS |  |  | Amazon
 | 2023-03-09 00:00:00 | Taxes (Lot-15) | Property Tax | Tax on Lot-15 Real Estate Tax for 2023 | 130.26 |  | Steel Purchase's |  | The [NAME] | 2030-01-31 00:00:00 |  | MORTGAGE  ESCROW SHORT |  |  | Tractor Supply
 | 2023-04-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for April | 903 |  | Grease - Oil - Lube |  | PAY-PAL | 2031-01-31 00:00:00 |  |  |  |  | TRACTOR SUPPLY
 | 2023-05-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for May | 803 |  | Plants, [NAME], Shrubs |  | Messicks | 2032-01-31 00:00:00 |  |  |  |  | The [NAME]
 | 2023-06-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for June | 803 |  |  |  | Ebay | 2033-01-31 00:00:00 |  | YEAR TO DATE (Less Ins Pmts) |  |  | PAYPAL
 | 2023-07-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for July  (Pd 6-28-23) | 803 |  |  |  | Harbor Freight Tools | 2034-01-31 00:00:00 |  | MORTGAGE PMT'S |  |  | Messicks
 | 2023-08-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for August (pd on 7-31) | 803 |  |  |  | True Value (Shrewsbury) | 2035-01-31 00:00:00 |  | Homeowner Ins Mthly Pmt |  |  | Ebay
 | 2023-08-03 00:00:00 | Taxes (House) | Property Tax | Tax on 160 High Ridge | 193.16 |  |  |  | [NAME]. Vendor | 2036-01-31 00:00:00 |  | Home Property Tax Mthly Pmt |  |  | Harbor Freight Tools
 | 2023-09-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for Sept (pd on 8-31) | 803 |  |  |  | Walmart | 2037-01-31 00:00:00 |  | Total Mortgage Only Pmts Made |  |  | Property Maintenance
 | 2023-09-05 00:00:00 | Taxes (Lot-15) | Property Tax | Tax on Lot-15 Real Estate Tax for 2023 | 368.29 |  |  |  | Property Maintenance | 2038-01-31 00:00:00 |  |  |  |  | Wellsfargo
 | 2023-10-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for [NAME] (pd on 9-31) | 803 |  |  |  | Wellsfargo | 2039-01-31 00:00:00 |  |  |  |  | Taxes (House)
 | 2023-11-01 00:00:00 | Wellsfargo | Mortgage | Mortgage pmt for [NAME] (pd on 10-30) | 803 |  |  |  | Taxes (House) | 2040-01-31 00:00:00 |  | CURRENT MONTH (Less Ins. Pmts) |  |  | Equipment Maintenance
 |  |  |  |  |  |  |  |  | Equipment Maintenance | 2041-01-31 00:00:00 |  | Current Mortage Pmt |  |  | Taxes (Lot-15)
 |  |  |  |  |  |  |  |  | Taxes (Lot-15) | 2042-01-31 00:00:00 |  | Total Current Month P&I Pmt | 505.26
 |  |  |  |  |  |  |  |  | * User input | 2043-01-31 00:00:00 |  | Amt Pd to Ins. & Taxes
 |  |  |  |  |  |  |  |  | * User input | 2044-01-31 00:00:00
 |  |  |  |  |  |  |  |  | * User input | 2045-01-31 00:00:00 |  | Insurance Pmts Yr to Date
 |  |  |  |  |  |  |  |  | * User input | 2046-01-31 00:00:00 |  | [NAME] on House Yr-Dt
 |  |  |  |  |  |  |  |  | * User input | 2047-01-31 00:00:00
 |  |  |  |  |  |  |  |  | * User input | 2048-01-31 00:00:00 |  | Insurance Pmts Cur-Mnth
 |  |  |  |  |  |  |  |  | * User input | 2049-01-31 00:00:00 |  | [NAME] on House Cur-Mnth
 |  |  |  |  |  |  |  |  | Metal Market | 2050-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  | H2
 |  |  |  |  |  |  |  |  |  |  | K2
 |  |  |  |  |  |  |  |  |  |  |  | DATE |  |  | AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2023-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | SELECT
 |  |  |  |  |  |  |  |  | wells fargo payments
 |  |  |  |  | 0
 |  |  |  |  | 0