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!

`FIND`

function, as well as the`COLUMN`

and`ROW`

functions. – Breakthrough Mar 18 '13 at 19:03