troubleshooting Question

Excel formula

Avatar of javaftper
javaftperFlag for Afghanistan asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
4 Comments1 Solution343 ViewsLast Modified:
In excel I am trying to calculate a number of tests that have passed (but only if they have a relevant test step).  IE- a count function based on two columns.

So, there are 2 columns – one displays test steps (some of these are blank), and another column showing if the test step has passed ( or not)

 I have been trying the countifs and counta functions but can not get it to return a figure only if both conditions are met i.e. test step is not blank and it has a “pass” status

any ideas?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
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 4 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