Automatic Sum by Category (SumIf extension)

  • Thread starter Thread starter ezuk
  • Start date Start date
E

ezuk

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 th
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 t
make it easy to add new categories.

Meaning, if the user inputs a category which doesn't exist yet in th
"category list", it will be recognized as a "new category" and will ge
its own cell with SumIf and everything.

Any ideas on how to implement it? I'm starting to think VBA is the wa
to go... But I don't like it so much.

What do you think?

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine best way to sum 4
SUMIFS function help 6
if and sumif 3
Adding some list items 1
How do I create a click on + symbol to open a root and click on -. 1
Grouping of Categories 1
summing line items by category 2
sumif with Month() function 8

Back
Top