COUNTIF function and Advanced Filter

[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

 

[wawrzyniak]

Now for some reason I can't get anything at all to filter. Anyone hav
any idea what is going on

 

[Max]

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"

 

[Max]

Not sure what happened here ..
But try the suggestion given in the earlier reply
The autofilter should work

 

[Aladin Akyurek]

Given the set up of your criteria range, fill in the empty cells in A3:M3
with *.

 

[Debra Dalgleish]

Your criteria cells for Excel and Outlook contain space characters.
Clear those cells, and the filter should work correctly.