Readin text in an if staement

I  have a nested If statement that must do a countif if two criterion are met. The first criteria iis that  a certain name must be found under the site name column, the second criteria is there must be some text in the  error column section. If both comments are met then a count  is to be done for each  piece of data that meets both criteria.  the statement follows
IF(AND(D6:D18="cheyenne",F6:F18<>""),COUNTIF(A6:F18,"b"),"fail") the is a spreadsheet also attached

Evauation id      reviewer      Tape-id      site name      capture date      errors
1      m      15      Bryan      3/12/2011      yes
1      m      15      Bryan      3/13/2011      yes
1      m      15      Bryan      3/14/2011      
1      m      15      Houston      3/15/2011      yes
1      m      15      Houston      3/16/2011      yes
1      m      15      Houston      3/17/2011      no
1      m      15      Tulsa      3/18/2011      no
1      m      15      Tulsa      3/19/2011      no
1      m      15      Tulsa      3/20/2011      no
1      m      15      Cheyenne      3/21/2011      
1      m      15      Cheyenne      3/22/2011      no
1      m      15      Cheyenne      3/23/2011      no
1      m      15      Cheyenne      3/24/2011      no



URS.xlsx