Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a schedule of resources assigned to projects. I have a filter that
filters out contracted and non-contracted projects. At the bottom of the sheet I have a countif function that counts the number of resources scheduled for each week for all projects and then I have a formula that translates that into hours. I would like when I autofilter the contracted projects - for the countif function to count only the resources for the projects shown from the autofilter. That would in turn recalculate the hours based off those resources. Any suggestions? See below. Contract? Project Resource Name Jan Feb Mar Apr May ... Y Client 1 B.SMITH 1 1 1 1 N Client 2 N.TAYLOR 1 1 1 # of Res 1 2 1 1 2 Hrs 320 640 320 320 640 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
checkout the SUBTOTAL function in Excel Help. It can operate on the visible
rows and ignore the rows filtered out. -- Gary''s Student gsnu200709 "Gayla" wrote: I have a schedule of resources assigned to projects. I have a filter that filters out contracted and non-contracted projects. At the bottom of the sheet I have a countif function that counts the number of resources scheduled for each week for all projects and then I have a formula that translates that into hours. I would like when I autofilter the contracted projects - for the countif function to count only the resources for the projects shown from the autofilter. That would in turn recalculate the hours based off those resources. Any suggestions? See below. Contract? Project Resource Name Jan Feb Mar Apr May ... Y Client 1 B.SMITH 1 1 1 1 N Client 2 N.TAYLOR 1 1 1 # of Res 1 2 1 1 2 Hrs 320 640 320 320 640 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Filter Not Displaying all results | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
how do I set the status bar to count results from filter? | Setting up and Configuration of Excel | |||
AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
Auto filter not displaying number of results in status bar. | Excel Discussion (Misc queries) |