Spreadsheet: 806710d1669503639-calculating-for-a-selected-catagory-and-based-on-selected-month-budget-tracker-example
Sheet: Sheet1

 | JAN - DEC       2022 |  |  |  |  |  |  |  | Amount Spent Per Category |  | CATEGORY | TYPE | SPECIFIC | NOTES
 | Status (Deposits Minus Expenditures) |  |  |  | (Spent) Year to Date Total |  |  | Deposits to Date | Select Category : | DEPOSIT | K | L | M | N
 |  |  |  |  | (Spent in) Current Month Total |  |  |  | Select Month : | 2022-05-23 00:00:00 | DEPOSIT | Social Security Deposit | [NAME] (Moxley Tank) | ALDi
 |  |  | Amt shown for selected Month |  | Average Spent Weekly |  |  | Deposits Current | Total Amount : |  | FOOD | Retirement Fund Deposit | APG FCU | Bird-In-Hand
 | 2022-11-23 00:00:00 | <---------Select Month |  |  |  |  |  |  |  |  | FUEL | Internal [NAME] | Argo mix Gas (Moxley Tank) | Boat
LINE | DATE | CATEGORY | TYPE | SPECIFIC | NOTES | AMOUNT |  |  |  |  | ELECTRIC | Refund | Consumer Cellular | Boat [NAME]
1 | 2022-01-01 00:00:00 |  |  |  |  | 0 |  | 0 | Estimated Yearly Net Funds |  | TELEPHONE | [NAME] | Diesel | [NAME]
 | 2022-01-04 00:00:00 | VEHICLE MAINT. & REPAIR | Groceries | [NAME] | [NAME] | 27.25 |  | 0 |  |  | TV - VIDEO - RADIO | Tax Refund | [NAME] | Drive Thru Food Eatery
 | 2022-01-04 00:00:00 | FOOD | Groceries | [NAME] | Saubels | 90.28 |  | 0 | Est. Yrly Funds : | 55000 | TRASH / REFUSE REMOVAL | Reimbursement | Farmers Markets & Roadside Stands | Ford PU
 | 2022-01-09 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 70.14 |  | 0 | Spent (Yr to Dt) : |  | VEHICLE MAINT. & REPAIR | Loan | Fast Food | Fred
 | 2022-01-12 00:00:00 | DEPOSIT | Social Security Deposit |  |  | 0 |  | 840.1 | Amt (Ov/Un) : |  | PROPERTY MAINT. & REPAIR | Automobile Fuel | Finance Co. | Generator (Trailer Mnt'd)
 | 2022-01-12 00:00:00 | DEPOSIT | Social Security Deposit |  |  | 0 |  | 1860.1 | Status : |  | EQUIPMENT MAINT. & REPAIR | Cars | Fred | [NAME]
 | 2022-01-13 00:00:00 | FOOD | Groceries | [NAME] | Redner's | 62.11 |  | 0 |  |  | HEALTH | CATV ([NAME]) | Fuel Oil | Giant
 | 2022-01-15 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 101.05 |  | 0 |  |  | VETERINARIAN | Cell Phones | Gas | Gifts & Donations
 | 2022-01-17 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 23.57 |  | 0 |  |  | INSURANCE | Dinners Out | [NAME] | Jeep
 | 2022-01-20 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 61.13 |  | 0 |  |  | MISC. | Equipment Fuel | Handy-Dandy | Kubota Lawn Tractor
 | 2022-01-24 00:00:00 | FOOD | Groceries | [NAME] | Saubels | 120.39 |  | 0 |  |  | CLOTHING | Garage | Ins. Automobile | KYMCO Side-By-Side
 | 2022-01-26 00:00:00 | DEPOSIT | Retirement Fund Deposit |  |  | 0 |  | 728.32 |  |  | LOAN | Groceries | Ins. Boat | Lawn Mower (Craftsman [NAME])
 | 2022-01-26 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 24.45 |  | 0 |  |  |  | Heating & Cooking | Ins. Dental | Lumber
 | 2022-01-26 00:00:00 | FOOD | Groceries | [NAME] | Redner's | 31.37 |  | 0 |  |  | MONTH | Homeowner Ins. | Ins. Medicare | Mitsubihsi
 | 2022-02-03 00:00:00 | DEPOSIT | Retirement Fund Deposit |  |  | 0 |  | 600.23 |  |  |  | House | Ins. Motorcycle | Motorcycle
 | 2022-02-03 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 152.67 |  | 0 |  |  | 2022-01-01 00:00:00 | Internet Video | Ins. Prescription Drug | Paint & Hardware
 | 2022-02-07 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 17.98 |  | 0 |  |  | 2022-02-23 00:00:00 | Life Ins. | [NAME] | Redner's
 | 2022-02-09 00:00:00 | DEPOSIT | Social Security Deposit |  |  | 0 |  | 840.1 |  |  | 2022-03-23 00:00:00 | Medical (Other) Non Covered | Loan (Equity) | Saubels
 | 2022-02-09 00:00:00 | DEPOSIT | Social Security Deposit |  |  | 0 |  | 1860.1 |  |  | 2022-04-23 00:00:00 | Medical Ins. | Loan (Finance Co.) | [NAME]
 | 2022-02-11 00:00:00 | FOOD | Groceries | [NAME] | Saubels | 77.23 |  | 0 |  |  | 2022-05-23 00:00:00 | Property | Loan (Personal) | Stone - Soil - Seed - Fertilizer
 | 2022-02-17 00:00:00 | FOOD | Groceries | [NAME] | Redner's | 93.55 |  | 0 |  |  | 2022-06-23 00:00:00 | Sabastian | Mortgage  (House) | Tractor
 | 2022-02-18 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 42.47 |  | 0 |  |  | 2022-07-23 00:00:00 | Tractor | Mortgage  (Land) | Utility Trailer
 | 2022-02-23 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 123.78 |  | 0 |  |  | 2022-08-23 00:00:00 | Vehicle Ins. | Oxygen Gas (Moxley Tank) | Volkswagon
 | 2022-02-25 00:00:00 | FOOD | Groceries | [NAME] | Saubels | 37.98 |  | 0 |  |  | 2022-09-23 00:00:00 | Yard & Grounds Equipment | Propane | Eat In
 | 2022-02-27 00:00:00 | FOOD | Groceries | [NAME] | Saubels | 30.15 |  | 0 |  |  | 2022-10-23 00:00:00 |  | [NAME]. Items
 | 2022-02-28 00:00:00 | DEPOSIT | Retirement Fund Deposit |  |  | 0 |  | 728.32 |  |  | 2022-11-23 00:00:00 |  | Repair & Parts
 | 2022-03-02 00:00:00 | FOOD | Groceries | [NAME] | Saubels | 75.42 |  | 0 |  |  | 2022-12-23 00:00:00 |  | Restaurant
 | 2022-03-03 00:00:00 | DEPOSIT | Retirement Fund Deposit |  |  | 0 |  | 600.23 |  |  |  |  | Verizon
 | 2022-03-06 00:00:00 | FOOD | Groceries | [NAME] | Redner's | 49.83 |  | 0 |  |  |  |  | Wood Pellets
 | 2022-03-08 00:00:00 | FOOD | Groceries | [NAME] | [NAME] | 83.98 |  | 0