Count Auto-filter results

G

Guest

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
 
G

Guest

checkout the SUBTOTAL function in Excel Help. It can operate on the visible
rows and ignore the rows filtered out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count only visible formula results 2
Count values in array of data where no blanks in one column 4
Counting values in an array where value in one column is not null 5
Formula Finesse Needed: COUNTIF or DCOUNT or Something better 2
Count If 1
Count if ? formula needed! 3
How to use the countif() function to count items in a table 2
Formula to count cell text by value 13

Top