I have a report I need to add something to. I have an employee sheet that is already showing the dollars grossed each month for each individual, but I want to get a little more in depth. I want to make it so a certain part of an invoice (specifically the first word only) is what I am looking for in order to logic off of. Here is an example, Sheet 1 is where the employees are and Sheet 2 is my data. For Person 1 I want the dollar amount added up for anything with the first word being WG. The data I want to pull is the dollar amount added up (the sum of all WG's for this individual) which is next to the WG in its own column.
Sheet 1, a cell for the formula next to collector
Sheet 2 (columns), Employee ID, Amount, Payment Type.