I am wondering if there is a way to select a cell that is a column two cells away by searching for a keyword.
The scenario is this, I have a budget spreadsheet that I use to budget daily. I want to make a cell do a quick sum calculation for any cell that is detailed as having the keyword “Gasoline” in it.
Ex. My spreadsheet has column A which is the money field ($ or -$ depending on if it’s income or expenditure), coulumn B is Date, and Column C is the details of the income/expenditure.
Cost | Date | Details
-$45.75 | 2020-01-16 | Gasoline fill up at Esso
I want to create a SUM formula that picks up any cell that is in C that has the word Gasoline, and takes it’s corresponding column A cell adding to a running total. So really, the column C (details) is just a way of finding the corresponding column A field.
I’ve been trying to research a way to do this, but really don’t know what keywords I should use to find this way of calculation.
Hopefully the above makes sense.