Afternoon all
I have a reasonable knowledge of Excel, but this is stumping me. On the example, each of the four workers have participated in Jobs A, B and C. The total jobs for each person is a straightforward SUM in Row 8. But I want to break down the total hours into each Job for each person. On the original spreadsheet the jobs are on a drop down selection, then the hours are manually input based on what they have done. Using Sandra as an example, is there a formula that can be put into cells E11, E13 and E15 that can add up the total hours she has done in relation to each Job? I want it to total up what it sees based in the drop down and the hours in relation to it.
Not sure if it is LOOKUP or something similar
Help is gratefully appreciated as always
Bookmarks