I'm trying to build a formula that looks across input data from one sheet (range C5:I52) and categorize it in another. It is a time tracking sheet. What I am trying to achieve is one sheet with input data, per 30 minutes, where I can put in for example Netflix from 22:00 to 23:00 in cell C49 & C50, and have in sheet2 Netflix added as a category under a value ranging from a dollar amount.
For example, Netflix would be a category under maybe $10 (not making traction to my goals - therefore a low value).
What I have tried is to create a LookUp formula with premade categories (e.g. for $10 maybe Netflix, and for $0 maybe Instagram, Snapchat, and other 'useless' activities) but I can't seem to get it to work. It would search how many times it can maybe find Snapchat in cells C5:I52 and then have that amount (let's say Netflix found 2 times - meaning 2 times 30 minutes - is 1 hour total) times $5, so if I would spend 1 hour a day on Netflix it would value my total activity for that week at $70.
The main things are to 1. search the amount of times a premade activities is found and 2. have that amount be a number (say if found 4 times it would be 30 minutes * 4 = 2 hours) and maybe have it 4 * $5 resulting in a $20 value for that category.
Hopefully, someone can help. The total value in dollar amount is a different column, on the right to the category. So let's say under column $10 it would say Snapchat in column D under $0, and column E is the amount of Hours in a dollar amount being Value. Then column F would be $10, column G value, etc.
The goal is to manually log time through an Input sheet, and have it valued automatically in an Output sheet.
