tommyl18
01-04-2014, 08:05 AM
Hi thanks for taking the time to look at this thread.
I have been trying to work out the best way to create a formula or formulas or even a macro to answer my following query.
I have staff that work for me on a regular basis for each day they work I make a specific amount of profit off each person.
I need to automatically work out how much profit each person is making me. I have attached photos to help explain, The only formulas I can think of are vlookup and countif together but will I need a lot of vlookup formulas for it to work?
Your help would be much appreciated thanks in advance.
I currently have a validation list for each specific person ie, Tom half day, Tom before tax, Tom after tax etc then I have a vlookup formula for there specific day rate in relation to that.
For example, I need to see how many times "Tom half day before tax" shows up in column G on the demolition sheet and multiply this by the profit shown in the table in the profit and loss sheet, once I have found that out I then need to do the same for
Tom full day before tax, Tom full day after tax, tom half day after tax. Once i have the totals from them I then need to add them together to give me the result which I need to go into C:3 in the profit and loss sheet. Hope this makes sense!!
I have been trying to work out the best way to create a formula or formulas or even a macro to answer my following query.
I have staff that work for me on a regular basis for each day they work I make a specific amount of profit off each person.
I need to automatically work out how much profit each person is making me. I have attached photos to help explain, The only formulas I can think of are vlookup and countif together but will I need a lot of vlookup formulas for it to work?
Your help would be much appreciated thanks in advance.
I currently have a validation list for each specific person ie, Tom half day, Tom before tax, Tom after tax etc then I have a vlookup formula for there specific day rate in relation to that.
For example, I need to see how many times "Tom half day before tax" shows up in column G on the demolition sheet and multiply this by the profit shown in the table in the profit and loss sheet, once I have found that out I then need to do the same for
Tom full day before tax, Tom full day after tax, tom half day after tax. Once i have the totals from them I then need to add them together to give me the result which I need to go into C:3 in the profit and loss sheet. Hope this makes sense!!