Coming up with a total which is dependent on the selection a drop down list

Hi everyone,

I am a newbie to the forum and hoping that I can get some help. I will apologise if this is addressed elsewhere, but I am not sure of the technical terms for what I am looking to do and I could't find an answer that seemed relevant to me. I will try my best to explain what I am looking to do.

I am trying to total up the number of hours an employee spends on each job / project. The table I have is as below:

Table.JPG

The "Job" is selected from a drop down list (which I have created), and the "Total Hours" is calculated via a formula.

What I would like to do now is create a formula which will automatically total the number of hours spent on each "Job" for the employee. The idea is that I can then have a separate sheet that will total up the amount of hours for each job for all employees. I am not even sure if this is possible, but here's hoping!

Any help is greatly appreciated.

Thanks,

Leanne

Leanne,
Use a Pivot Table.

Thanks AB33,

I only have a basic understanding of Pivot Tables, but I don't think that the totals will automatically update. If the total hours per Job were calculated via formula, it would update each time the table was updated. Or maybe I am missing something?

thanks

Leanne

Leanne,
Yes you are right you need to refresh a pivot table to get an update value, but you can include a macro code which auto pivot table. If you change the source data, it will auto show in output data(Pivot table). I can also understand if you do not want to go the route of a macro code.

Hi AB33,

Macro Codes is something that is above me. I think that I will stick to formulas and pivot tables.

Thanks again,

Leanne