Matching variables between cells

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hey folks,

So here's my problem:

I'm creating an excel document to keep track of my personal expenditure -- the layout right now represent a calender for each month, with the weeks separated by columns (i.e. Column A listing Monday through Sunday, week 1 in column B, week 2 in column C and etc). For each day, I have been listing my expenses like so;

Cell B5: Breakfast, Coffee, Train, Beer, Groceries
Cell B6: =11+2+2+1.5+30

So essentially, I list all the items I purchased in one cell (B5), then underneath (B6) list all the costs that add up to the daily total.

I would now like to create statistics in reference to my spending, like how much I spend on coffee, groceries etc.

Is there any way that I can match f.ex. Groceries with 30 by keeping the present layout? Basically I need to create an IF statement that recognizes the word "groceries" inside a cell, then determines its position (indicated by commas), and then finds the matching position in the cell below (indicated by plus) and outputs that cost.

I'm hoping this can be done without macros, but at this point I would appreciate any input!

Dennis


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Without macro it would be hard to do it and may be not worth the effort. One way without macro and perhaps very much DO-IT-YOURSELF would be you change your sheet design, And have each individual item listed individually in cells instead this combo manner.