I am trying to create a household and small business spending sheet. I have a bunch of cells wherein I enter receipts to keep track of my spending. when I do my taxes I can write off some of these receipts. The IRS generally asks for the deductible receipts to be categorized.
Is it possible in Excel to create categories "tags" (not sure how to put that), in order to have a certain cell display the total spending of a certain category "tag", let us say for example "office supplies" category (or category "1234" for another )? To explain: Rather than create a separate category listing for each category, is it possible to "tag" certain cells in my spending sheet, so that they automatically are summed in the a category total cell? So for instance I have a column that represent all 2010 January spending. I enter all of my receipts there, certain cells I tag as "office supplies" category, those amounts are automatically totaled into the office supply category total cell, that is added to the sum formula of the "total" cell.
Thanks for reading, I hope my question was clear.
Wolfy
Hello Wolfy, welcome to the forum.
Enter your data in a simple table format. One row for each receipt. The coulumns should include something like
Date......Amount.........Category
You can use data validation in the Category column to make sure the entered categories are always spelled correctly.
Then you can run a simple pivot table on your data, where you can sum and filter by Date and Category.
Here's where you should have a look for
Data validation: http://www.contextures.com/xlDataVal01.html
Pivot tables: http://peltiertech.com/Excel/Pivots/pivotstart.htm
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks