LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Filtering results

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering results to another sheet zhj23 Excel Discussion (Misc queries) 2 May 9th 07 03:16 AM
sorting and filtering results E Savard Excel Worksheet Functions 3 April 27th 07 08:17 PM
Conditional Sum Argument results do not equal cell results Excel Randy R Mullins Excel Worksheet Functions 3 August 9th 06 07:16 PM
display count/results of filtering Excel in status bar JayDax Excel Discussion (Misc queries) 2 July 21st 05 11:41 PM
trouble filtering a list. Why isn't column filtering? Pat Excel Worksheet Functions 1 July 18th 05 03:30 PM


All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"