Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Sum by Category (SumIf extension)
Hello, I'm making a budget spreadsheet. This is before-the-fact accounting -- you budget everything and _then_ spend the money. Each line contains an expense description, and a category for the expense. I want to make a neat list of the total sum in each category. This would be easy to do using SumIf, if not for one thing: I want to make it easy to add new categories. Meaning, if the user inputs a category which doesn't exist yet in the "category list", it will be recognized as a "new category" and will get its own cell with SumIf and everything. Any ideas on how to implement it? I'm starting to think VBA is the way to go... But I don't like it so much. What do you think? Thank you. -- ezuk ------------------------------------------------------------------------ ezuk's Profile: http://www.excelforum.com/member.php...o&userid=26177 View this thread: http://www.excelforum.com/showthread...hreadid=394906 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
sumif function with a difference | Excel Worksheet Functions | |||
Linking Several Worksheets to One Worksheet | Excel Discussion (Misc queries) | |||
Rank() based on category | Excel Worksheet Functions |