Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to track time between products and phases. Initially, I had this, and
it gave me the correct information: A$3 references the 'label' ALPHA1 on the current sheet, that I am getting the total hours from on the Details sheet: =SUMIF(Details!$G12:$G2000,A$3,Details!$E12:$E2000 ) Now, I want to add a futher breakdown: THis product has 2 current releases in various phases. I want to track the ALPHA1 time for version 7.1.0 in a separate column for totally than the 7.2.0 version. ON the details sheet, I have the F column that contains the version info (7.1.0 or 7.2.0) So, what I need is to be able to check for 7.1.0 or 7.2.0, then the Phase (Alpha1, Beta2, etc.), and add to the appropriate total on the summary sheet. There will be a column for 7.1.0 and a column for 7.2.0, and the rows are the ALPHA1, ALPHA2, etc. So, how do I fix? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filtering results to another sheet | Excel Discussion (Misc queries) | |||
sorting and filtering results | Excel Worksheet Functions | |||
Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
display count/results of filtering Excel in status bar | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |