PalaceOzzy
New Member
- Joined
- Feb 9, 2017
- Messages
- 3
Hi all,
I am completely stuck with how to get around my spreadsheet problem. I have a simple example of what I am trying to achieve listed below.
Sheet 1 'Product Unit rates per Customer' is a list of Products in column A and the different individual customer rates per product to be calculated in subsequent columns.
Sheet 2 'Time taken per resource - hours' is a list of the jobs in column A needed to complete the products and the hours taken for each job per product in subsequent columns. Not all jobs are required per product.
Sheet 3 'Resource pay per hour' is again a list of the jobs needed in column A and the different individual customer rates per job title in subsequent columns.
So by using the data in sheets two and three the cells in sheet one are (hopefully) to be auto-calculating the total cost of making each of the products dependent on the resource needed and the individual customer rates.
e.g.
It looks at the hours required for the necessary jobs that are needed and multiplies that by rates of those job types dependent on the customer.
I have explored VLOOKUP combinations with SUMIFS but it is getting me confused! Any help would be greatly appreciated.
I have a simple spreadsheet with these worksheets laid out but I fully appreciate the no upload rules.
I am completely stuck with how to get around my spreadsheet problem. I have a simple example of what I am trying to achieve listed below.
Sheet 1 'Product Unit rates per Customer' is a list of Products in column A and the different individual customer rates per product to be calculated in subsequent columns.
Sheet 2 'Time taken per resource - hours' is a list of the jobs in column A needed to complete the products and the hours taken for each job per product in subsequent columns. Not all jobs are required per product.
Sheet 3 'Resource pay per hour' is again a list of the jobs needed in column A and the different individual customer rates per job title in subsequent columns.
So by using the data in sheets two and three the cells in sheet one are (hopefully) to be auto-calculating the total cost of making each of the products dependent on the resource needed and the individual customer rates.
e.g.
It looks at the hours required for the necessary jobs that are needed and multiplies that by rates of those job types dependent on the customer.
I have explored VLOOKUP combinations with SUMIFS but it is getting me confused! Any help would be greatly appreciated.
I have a simple spreadsheet with these worksheets laid out but I fully appreciate the no upload rules.
