Tracking Expenses
I created a spreadsheet to track all the groceries that I buy at work for our employee cafe. (see attached) I need to be able to pull up the following information when needed: How much is spent each month and each year.
You can see from the attached spreadsheet; I used the SUBTOTAL function. I'm thinking that this might not be the best way to set this up because I'll keep adding groceries to the list and by using SUBTOTAL, I will have to keep applying the SUBTOTAL each week. Someone who is not proficient with Excel will be using this and I don't want to make this very complicated for her. What is the best way to set this up? HELP!
Your help is greatly appreciated.
TIA,
Karen
|