Spreadsheet: 857479d1706496597-need-help-with-formulas-that-dont-calculate-fuel-costs-example-sht-jan-24
Sheet: Sheet1

 |  |  |  | Cost of Heating & Cooking Fuel Year ---> |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | YEARS
 | Choose a month >> | 2022-01-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  | BILLING PERIOD | AMT | GALLONS USED | COST PER GALLON |  | Total Spent Year to Date |  | Total Spent (Previous Year) |  |  | Amount Spent Monthly Yr to Dt |  |  | Current Month Total |  |  |  |  | 2023-01-01 00:00:00
 | COST FOR LP SELECTED MONTH |  |  |  |  |  |  |  |  |  |  |  |  | AMT Spent |  | Amt Spent |  |  |  |  |  | 2024-01-01 00:00:00
 |  |  |  | 2022-01-26 00:00:00 | 136.66 | 45.1 |  |  |  |  |  |  |  | By [NAME] |  | On [NAME] |  |  |  |  |  | 2025-01-01 00:00:00
 |  |  |  | 2022-02-21 00:00:00 | 87.77 | 27.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026-01-01 00:00:00
 | COST FOR LP CURRENT MONTH |  |  | 2022-03-25 00:00:00 | 99.9 | 30.1 |  |  | VENDOR | Date | [NAME] Purchased | Cost Per Ton | Total  For Tonage | # of Bags | Cost Per Bag | Total For Bags Of Pellets | Total Spent For Pellets |  |  |  |  | 2027-01-01 00:00:00
 |  |  |  | 2022-09-30 00:00:00 | 206.7 | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2028-01-01 00:00:00 |  |  | Unique | Yearly Cooking & Heating Fuel Cost
 |  |  |  | 2022-12-14 00:00:00 | 142.91 | 46.1 |  |  | Tractor Supply | 2023-01-11 00:00:00 |  |  | 0 | 25 |  | 154.75 |  | 1 |  |  |  | 2029-01-01 00:00:00 |  |  | Month # | MONTH | GAS | PELLETS | TOTAL
 | TOTAL LP FUEL COST FOR YEAR |  |  | 2023-01-01 00:00:00 | 152.81 | 50.1 |  |  | Tractor Supply | 2023-02-08 00:00:00 |  |  |  | 6 |  | 37.74 |  |  |  |  |  | 2030-01-01 00:00:00 |  |  |  | January
 |  |  |  | 2023-02-01 00:00:00 | 77.31 | 25.1 |  |  | Tractor Supply | 2023-02-15 00:00:00 |  |  |  | 6 |  | 37.14 |  |  |  |  |  | 2031-01-01 00:00:00 |  |  |  | February
 |  |  |  | 2023-03-01 00:00:00 | 120 | 40 |  |  | Tractor Supply | 2023-02-28 00:00:00 |  |  |  | 6 |  | 37.14 |  |  |  |  |  | 2032-01-01 00:00:00 |  |  |  | March
 | AVG YRLY LP COST PER MONTH |  |  | 2023-09-13 00:00:00 | 90.56 | 35.1 |  |  | Tractor Supply | 2023-03-05 00:00:00 |  |  |  | 6 |  | 37.14 |  |  |  |  |  | 2033-01-01 00:00:00 |  |  |  | April
 |  |  |  | 2023-12-13 00:00:00 | 223.08 | 85.8 |  |  | Tractor Supply | 2023-03-09 00:00:00 |  |  |  | 10 |  | 61.9 |  |  |  |  |  | 2034-01-01 00:00:00 |  |  |  | May
 |  |  |  | 2024-01-15 00:00:00 | 80.6 | 31 |  |  | The [NAME] | 2023-09-19 00:00:00 | 2 |  | 598 |  |  |  |  |  |  |  |  | 2035-01-01 00:00:00 |  |  |  | June
 | AVG YRLY GAL LP USED PER MONTH |  |  |  |  |  |  |  | Tractor Supply | 2024-01-26 00:00:00 |  |  |  | 12 |  | 79.08 |  |  |  |  |  | 2036-01-01 00:00:00 |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2037-01-01 00:00:00 |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2038-01-01 00:00:00 |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2039-01-01 00:00:00 |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2040-01-01 00:00:00 |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2041-01-01 00:00:00 |  |  |  | December
 | TOTAL COST OF PELLETS FOR FOR SELECTED YEAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2042-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2043-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2044-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2045-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2046-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2047-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2048-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2049-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2050-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2051-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2052-01-01 00:00:00
 |  |  |  |  |  |  |  |  | Tractor Supply | 2023-01-11 00:00:00 |  |  |  | 6.19
 |  |  |  |  |  |  |  |  | Tractor Supply | 2023-02-08 00:00:00 |  |  |  | 6.29
 |  |  |  |  |  |  |  |  | Tractor Supply | 2023-02-15 00:00:00 |  |  |  | 6.19
 |  |  |  |  |  |  |  |  | Tractor Supply | 2023-02-19 00:00:00 |  |  |  | 6.19
 |  |  |  |  |  |  |  |  | Tractor Supply | 2023-02-28 00:00:00 |  |  |  | 6.19
 |  |  |  |  |  |  |  |  | Tractor Supply | 2023-03-05 00:00:00 |  |  |  | 6.19
 |  |  |  |  |  |  |  |  | Tractor Supply | 2023-03-09 00:00:00 |  |  |  | 6.19
 |  |  |  |  |  |  |  |  | The [NAME] | 2023-09-19 00:00:00 | 299