I'm making a budget/finances sheet for my small business and wanted to see if there was any way to automate what I'm currently doing manually.
I have 1 section each for my summed variable expenses and summed fixed expenses, plus 3 sections for expense tracking. What I'm wanting to do is when the category in the tracking sections matches the category of my fixed or variable expenses, add the number in that row to the total sum.
Variable Expenses
Category - N5:N19
Spent (Sum) - P5:P19
Fixed Expenses
Category - N25:N39
Spent (Sum) - P25:P19
Expense Tracking
Category - B45:B145, H45:H145, N45:N145
Spent - E45:E145, K45:K145, Q45:Q145
If it makes a difference, I converted all my separate sections into different tables so I could filter A-Z without messing up my whole sheet, but if this automation works i can unconvert or whatever, especially if it would break the formula.
If there is anymore info needed, let me know and I'll give it to you.
Edit1: Using Chrome, I'll be the only one using this document, I'm a beginner, and I'll be adding expenses to the expense tracking section every day or every other day.
Feel free to mess with this, this has no important info on it.