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?
Microsoft ExcelMicrosoft ApplicationsMicrosoft Office
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.