I have a vertical column of dollar amounts of purchases. The next column to the right contains the category that each purchase falls under (for example, “food”, “utilities”, “entertainment”, etc.). So, each purchase amount has a category entry to its immediate right. Is there a way that I can do a sum of all “food” purchases? That is, excel would have to add up all the dollar amounts that are categorized (and immediately to the left of the category label) as “food”.
Any suggestions?
Yes, there is an “if” function, I have used it in the past, but I do not have excel handy just now to tell you the exact syntax. I think it might have been “SUMIF”, search for that.
Sure, don’t know what version you have but you want the ‘subtotal’ button somewhere on your toolbar/ribbon.
I’m using google spreadsheet, which seems to work pretty similar to excel as far as formulas.
Google spreadsheets I don’t know, but in Excel you’d want a pivot table.
Subtotal only works if the expenses are sorted by the category. Sumif would work, but pivot table does all the work of creating those sumifs for you.
How do you do a sumif with the criteria being that the cell to be summed has a cell to the immediate right that contains a particular word?
^^Nevermind, I got it. Thanks, the Sumif takes care of it.