Hi,
I have just created a Credit Card Statement project on Excel (using the pre-made "Credit Card Statement" template under "Ledger Sheets" in the Project Gallery.) The template is great, because it automatically totals my credit expenses in a separate "Balance” column as they’re input. It also enables me to click on the column labeled “Category,” and only look at expenses in certain categories (e.g. groceries, dining, etc.) My problem is, I’d like to see total amounts spent in those specific categories without any other expenses being considered in this sum, nut when I look at expenses in only one category, the “Balance” column still reflects other purchases made in other categories (that is, the value in the Balance column seems to jump because it’s adding stuff from other categories not displayed on the sheet.) I would just Autosum the Credit column once the category has been selected, but with this template, Autosum is grayed-out. I’ve checked, and the sheet is not protected, so I don’t think that’s the issue. Sorry this question is so long!
Thanks,
Danny
System Specs: MacBook
Mac OS X 10.7.4
Microsoft Excel 2008 for Mac
Version 12.3.3 (120411)
Latest Installed Update 12.3.3
Bookmarks