I don't think this should be too complicated for Excel, but I am trying to figure out how to:
1) Determine if a cell in column A contains the text "FF"
2) If so, jump over to the corresponding cell in Column D and add its value
3) Do this all the way down the A column, keeping a running total of all cells in column D if the cell in column A meets the criteria
Basically, I am breaking down a checkbook register by transaction types, such as Groceries, Clothing, Fast Food, Bills, etc. I want to calculate how much money has gone toward each category.
Any help you can provide will be greatly appreciated. Thank you!