Numbers calculating totals based on column input
Essentially, trying to make my own spreadsheet for only tracking expenses. With all the expenses laid out, I'm wanting to have each category total up automatically.
Example: Any time I add an expense such as "food" or "household", I want it to have a separate table or chart showing the total for each category that automatically updates as well.