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

Attached Files

Weekly Grocery List.xlsx (379.2 KB, 12 views)