Number's Formula: SUM based on Category
Hello,
I am creating a document in Numbers for a budget. Each expense has is related to one of six categories It looks a like this:
| Category | Company | Amount |
|---|---|---|
| Supplies | ACME, Inc. | £10 |
| Invitations | Example Company | £4 |
| Supplies | Party Depot, Inc. | £24 |
| Treats | The Fake Cake Bakery | £16 |
As I add expenses, a category is chosen via a drop-down menu. Once all the data is input, I am looking to create a summary table that looks like this:
| Category | Total |
|---|---|
| Supplies | TOTAL OF SUPPLIES |
| Invitations | TOTAL OF INVITATIONS |
| Treats | TOTAL OF TREATS |
I am having difficulty creating the summary table as the "TOTAL OF X" needs to be calculated as I add and adjust data.
Eventually I would like to create a charts based on the Total Table information.
Numbers 2013
