Hey guys, So I have a list of total monthly salary for each person. The trouble is each person is split among 16 jobs with various percentages. Is there a simple formula to sum all of the salary devoted to each job without building out monthly calculations for each project?
My data is arranged as cell A3-L97 is the monthly salaries then columns N3-AD97 is the percentage spent on a particular job. All I am trying is a formula to calculate salary based on each job per month.
Any ideas or do I need to build it out?
My data is arranged as cell A3-L97 is the monthly salaries then columns N3-AD97 is the percentage spent on a particular job. All I am trying is a formula to calculate salary based on each job per month.
Any ideas or do I need to build it out?