troubleshooting Question
Excel formula
asked on
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?
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.
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.