Spreadsheet: 838951d1691548756-how-can-i-wriet-a-formula-based-on-year-selected-health-ins-example_2023-fh
Sheet: Sheet1

 | HEALTH INSURANCE                                                       SELECT YEAR OF INTEREST > - |  |  |  | 2022-01-01 00:00:00
 |  |  |  | Current Year Insurance Cost  ----> |  | Need to show total based on (F1)
 | Select |  |  | Previous Year Insurance Cost  ----> |  | Need same but for prior year of (F!)
 |  |  |  | PAID IN CURRENT MONTH  ----> |  | Need to show total for current month
 | August | <<                           Amt Spent During Month Selected                          >> |  |  |  | Need to show total based on (B5) | Break - Down |  |  |  | INSURANCE TYPE |  | MONTH |  | YEAR
 | DATE | INSURANCE | INDIVIDUAL | Decription | AMOUNT | Total Spent in Current -----> | Year |  | Month |  | Choose Ins. Type ! |  | January |  | 2022-01-01 00:00:00
 | 2022-01-12 00:00:00 | Medicare Ins | Individual #1 |  | 170.1 | Medicare Ins > |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  |  | Y=1-1-2023,12-31-2023=YEAR
 | 2022-01-12 00:00:00 | Supplimental Ins | Individual #1 |  | 144.99 | Supplimental Ins > |  |  |  |  | Medicare Ins |  | March
 | 2022-01-12 00:00:00 | Perscription Ins | Individual #1 |  | 33.2 | Perscription Ins > |  |  |  |  |  |  | April
 | 2022-01-12 00:00:00 | Dental Ins | Individual #1 |  | 38.37 | Dental Ins > |  |  |  |  | Supplimental Ins |  | May
 | 2022-01-12 00:00:00 | Vision Ins | Individual #1 |  | 2 | Dental Out of Pocket > |  |  |  |  |  |  | June
 | 2022-01-31 00:00:00 | Deductible Costs / Pmts | Individual #1 |  | 94.87 | Vision Ins > |  |  |  |  | Perscription Ins |  | July
 | 2022-02-12 00:00:00 | Medicare Ins |  |  | 170.1 | Vision Out of Pocket > |  |  |  |  |  |  | August
 | 2022-02-12 00:00:00 | Supplimental Ins |  |  | 144.99 | Deductible Costs > |  |  |  |  | Dental Ins |  | September
 | 2022-02-12 00:00:00 | Perscription Ins |  |  | 33.2 |  |  |  |  |  |  |  | October
 | 2022-02-12 00:00:00 | Dental Ins |  |  | 38.37 |  |  |  |  |  | Out of Poctekt (Dental) |  | November
 | 2022-03-12 00:00:00 | Medicare Ins |  |  | 170.1 |  | Total Mntly Video: |  |  |  |  |  | December
 | 2022-03-12 00:00:00 | Supplimental Ins |  |  | 144.99 |  | Total Year Video: |  |  |  | Vision Ins
 | 2022-03-12 00:00:00 | Perscription Ins |  |  | 33.2
 | 2022-03-12 00:00:00 | Dental Ins |  |  | 38.37 |  | INDIVIDIUAL |  |  |  | Out of Pocket (Vision)
 | 2022-03-31 00:00:00 | Deductible Costs / Pmts |  |  | 94.87 |  | Select Name !
 | 2022-04-12 00:00:00 | Medicare Ins |  |  | 170.1 |  | Individual #1 |  |  |  | Deductible Costs / Pmts
 | 2022-04-12 00:00:00 | Supplimental Ins |  |  | 144.99 |  | Individual #2
 | 2022-04-12 00:00:00 | Perscription Ins |  |  | 33.2
 | 2022-04-12 00:00:00 | Dental Ins |  |  | 38.37
 | 2022-05-12 00:00:00 | Medicare Ins |  |  | 170.1
 | 2022-05-12 00:00:00 | Supplimental Ins |  |  | 144.99
 | 2022-05-12 00:00:00 | Perscription Ins |  |  | 33.2
 | 2022-05-12 00:00:00 | Dental Ins |  |  | 38.37
 | 2022-05-31 00:00:00 | Deductible Costs / Pmts |  |  | 6
 | 2022-06-12 00:00:00 | Medicare Ins |  |  | 170.1
 | 2022-06-12 00:00:00 | Supplimental Ins |  |  | 144.99
 | 2022-06-12 00:00:00 | Perscription Ins |  |  | 33.2
 | 2022-06-12 00:00:00 | Dental Ins |  |  | 38.37
 | 2022-06-30 00:00:00 | Deductible Costs / Pmts |  |  | 103.49
 | 2022-07-12 00:00:00 | Medicare Ins |  |  | 170.1
 | 2022-07-12 00:00:00 | Supplimental Ins |  |  | 144.99
 | 2022-07-12 00:00:00 | Perscription Ins |  |  | 33.2
 | 2022-08-12 00:00:00 | Dental Ins |  |  | 38.37