Avatar of javaftper
javaftper
Flag for Afghanistan asked on

Excel formula

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

Avatar of undefined
Last Comment
javaftper

8/22/2022 - Mon
Saqib Husain

Can you upload a small sample file?
ASKER CERTIFIED SOLUTION
Saqib Husain

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
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.
ask a question
Patrick Matthews

Another alternative would be a PivotTable, using count as the aggregation method.

The nice thing about a PivotTable is that it allows you to get the counts for all of your combinations.
javaftper

ASKER
Thank-you.
Just what I wanted.
Your help has saved me hundreds of hours of internet surfing.
fblack61