Formula for totalling based on a drop down choice

[TG215]

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

[JohnTopley]

Where is "Sandra's" data ?

[Glenn Kennedy]

Your sample does not relate to your description!! The row numbers are incorrect... there are no jobs A, B & C and so on. Please check the file that you attached.

[TG215]

Afternoon, apologies wrong sample, stand by!!

[TG215]

My apologies, this should be the right sample

TG215

[Glenn Kennedy]

That's a relief. It really made think that I'm going soft in the head.

[JohnTopley]

In E11

=SUMIFS(E$3:E$6,$D$3:$D$6,$D11)

copy across to other cells E:H)

then copy to rows for other jobs

[Glenn Kennedy]

Delete the POINTLESS balnk rows in the results section. They just make it difficulat to drag the formula down. Then use:

=SUMPRODUCT(($D$3:$D$6=$D11)*(E$3:E$6))

copied across and down.

[TG215]

John and Glenn, you are both wizards of your craft. I thank you both for your input, much appreciated!!!

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.