COUNTIF function and Advanced Filter

  • Thread starter Thread starter wawrzyniak
  • Start date Start date
W

wawrzyniak

I currently have a small "database" that includes a column that uses th
COUNTIF function. It is essentially telling me how many certification
someone has received, based upon the previous columns (different type
of certification), which is determined by a "Y" or "N" in the precedin
cells. Now I have an advanced filter set up and I cannot figure ou
what I am supposed to put in the cell to filter out those people wh
have passed 4 tests or more. I do not understand why " >=4 " simpl
placed in the criteria cell won't work, because that is showing in th
cell. Do I have to do another type of COUNTIF formula? Help

Attachment filename: office xp mous certification database c incomp.xl
Download attachment: http://www.excelforum.com/attachment.php?postid=50641
 
Now for some reason I can't get anything at all to filter. Anyone hav
any idea what is going on
 
Try this:

Put in N11:

=IF(COUNTIF(F11:L11,"Y")>=4,"Pass","Fail")

Copy N11 down to N31

This will extract the status of candidates as either "Pass" or Fail"
[ "Pass" = those who passed 4 or more of the tests in cols F to L ]

Do an autofilter in N10 > select "Pass"
 
Not sure what happened here ..
But try the suggestion given in the earlier reply
The autofilter should work
 
Given the set up of your criteria range, fill in the empty cells in A3:M3
with *.
 
Your criteria cells for Excel and Outlook contain space characters.
Clear those cells, and the filter should work correctly.
 
Back
Top