Forum Discussion
Solved
Tracking Profit
I want a column to be able to calculate BASIC profitability of a job. If the crew leader column (P) says "Jonathan", I want column T (not created yet), to take the total price of the job (column J) a...
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.
The total in the hours column is both the employees together, so total hours combined. So each having worked 6 hours/each.
And if there's one person listed in Crew Leader (column P) and two listed under Crew Member (column Q), Column I is still the combined hours between all the people together.