| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
