troubleshooting Question

Readin text in an if staement

Avatar of Marv031261
Marv031261 asked on
Microsoft Excel
3 Comments1 Solution181 ViewsLast Modified:
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

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros