Ok. So I'm basically making a budget spreadsheet. Yea, there are other apps out there that help with this. But I have a few specific things I want to get out of this so I figure a custom spreadsheet is best.
What I have is a sheet, with a table that has a few columns. One column is a description, one is a date, one is a popup menu column and the last (so far) is a cost.
The popup menu column allows me to select a category (food, clothing, automotive, etc) that I'm spending money in. I'd like to be able to tally the column and get a SUM based on each category. So something like this,
if PopupMenu = Food Then SUM(columnG)
A more appropriate version would be
For x = 1 to totalrows
if popupmenu = Food then
foodTotal += cost
But that isn't possible to do. I was hoping there'd be some way of doing it with SUMIF or SUMIFS command. Documentation is sorta lacking.
Any suggestions?
What I have is a sheet, with a table that has a few columns. One column is a description, one is a date, one is a popup menu column and the last (so far) is a cost.
The popup menu column allows me to select a category (food, clothing, automotive, etc) that I'm spending money in. I'd like to be able to tally the column and get a SUM based on each category. So something like this,
if PopupMenu = Food Then SUM(columnG)
A more appropriate version would be
For x = 1 to totalrows
if popupmenu = Food then
foodTotal += cost
But that isn't possible to do. I was hoping there'd be some way of doing it with SUMIF or SUMIFS command. Documentation is sorta lacking.
Any suggestions?