- Joined
- Dec 4, 2007
- Messages
- 41
- Reaction score
- 1
- Points
- 8
- Location
- Durham, NC
- Your Mac's Specs
- Retina MacBook Pro (15")
Okay, got an interesting Numbers question for y'all.
I have a table set up for categorizing expenses for work. One of my column's is a "category" and has a drop-down box for four various categories to select.
I also have a total dollar amount column. It totals up at the bottom for ALL expenses.
I want to add some additional cells that only add up the amounts of the "total dollar amount" column that share a row with each specific category in the "category" column.
I.E. - I want four individual cells that add up and display the amounts of only the "category x" "category y" and "category z" rows (separately) of the "Category" column.
Hope that makes sense - anyone know how to accomplish this? Thanks very much!
I have a table set up for categorizing expenses for work. One of my column's is a "category" and has a drop-down box for four various categories to select.
I also have a total dollar amount column. It totals up at the bottom for ALL expenses.
I want to add some additional cells that only add up the amounts of the "total dollar amount" column that share a row with each specific category in the "category" column.
I.E. - I want four individual cells that add up and display the amounts of only the "category x" "category y" and "category z" rows (separately) of the "Category" column.
Hope that makes sense - anyone know how to accomplish this? Thanks very much!