Pivot table help?
 

Hi
I've got a list of job numbers in column a, with a list of hours worked in
column b. There are a number of repeating jobs in column a as some jobs
have multiple operations on them. I can do a pivot table to see the total
hours worked on each job, but i need to analyse it further. I also have a
list of a particular type of job in column c. What I need to know is the
total hours, per job, only for those jobs in column c. If the job is in A,
but not C, i'm not interested in it.

Can anyone help? I have attached a very small sample.

Thanks, Scott

Job Worked Non Int
7814 0.22 7814
7814 0 7817
7818 2.7 7818
7818 0 7819
7819 1.3 7820
7819 0.06 7821
7819 0 7822
7819 0 7823
7820 2.4 7824
7820 0.12 7825
7820 1.64 7826
7820 0 7827
7820 0 7828
7820 0 7829
7821 1.1 7830
7821 0 7831
7824 4.86 7832
7824 0 7833
7824 0 7834
7824 0 7835
7824 0 7836

Pivot table help?
 

Hi,
Enter the jobs # in column D and then in E use

=sumproduct(--($A$1:$A$1000=D1),--($C$1:$C$1000)=D1),$B$1:$B$1000)

change the ranges to fit your needs

"Scott" wrote:

Hi
I've got a list of job numbers in column a, with a list of hours worked in
column b. There are a number of repeating jobs in column a as some jobs
have multiple operations on them. I can do a pivot table to see the total
hours worked on each job, but i need to analyse it further. I also have a
list of a particular type of job in column c. What I need to know is the
total hours, per job, only for those jobs in column c. If the job is in A,
but not C, i'm not interested in it.

Can anyone help? I have attached a very small sample.

Thanks, Scott

Job Worked Non Int
7814 0.22 7814
7814 0 7817
7818 2.7 7818
7818 0 7819
7819 1.3 7820
7819 0.06 7821
7819 0 7822
7819 0 7823
7820 2.4 7824
7820 0.12 7825
7820 1.64 7826
7820 0 7827
7820 0 7828
7820 0 7829
7821 1.1 7830
7821 0 7831
7824 4.86 7832
7824 0 7833
7824 0 7834
7824 0 7835
7824 0 7836