Forum Discussion
Tracking Profit
Let's say you create a new worksheet in the same workbook and name it Rates.
In A1, enter Employee and in B1, enter Hourly Rate.
In A2, A3 etc., enter the names of the employees (Jonathan etc.).
In B2, B3 etc., enter the corresponding hourly rates.
Go back to the profit sheet.
Enter the following formula in T2:
=J2-I2*IFERROR(VLOOKUP(P2, Rates!$A$2:$B$1000, 2, FALSE), 0)
If you want to take multiple crew members into account, please provide more detailed information about the setup.
What if there's multiple crew members on the same job?
Let's say you create a new worksheet in the same workbook and name it Rates.
In A1, enter Employee and in B1, enter Hourly Rate.
In A2, A3 etc., enter the names of the employees (Jonathan etc.).
In B2, B3 etc., enter the corresponding hourly rates.
Go back to the profit sheet.
Enter the following formula in T2:
=J2-I2*IFERROR(VLOOKUP(P2, Rates!$A$2:$B$1000, 2, FALSE), 0)
If you want to take multiple crew members into account, please provide more detailed information about the setup.
HansVogelaar I've entered the formula suggested and this is what shows up. I've also included a screenshot of the rates spreadsheet as well. It doesnt seem to be working. I know on two of them there are blanks in the Crew Leader column, but the others, "David", "Elias", "Josue" and "Miguel" are all input on the rates spreadsheet. Do you see something I'm doing wrong perhaps?
Could you attach a sample workbook with anonymized data?
HansVogelaar Will this work?
- Perfect! Thank you! Yes, so for multiple crew leaders on the same job, we have in the same cell "Adam/Jonathan" Then those crew leaders also sometimes have their own crew MEMBERS. So on one job, it could potentially be 3-5 people on one big job. So Crew Leader (column P) might have "Adam/Jonathan" and Crew Member (column Q) might have "Devin/Lorenzo". Is there a formula for this scenario?
