Excel formula

javaftper
javaftper used Ask the Experts™
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Saqib Husain, SyedEngineer

Commented:
Can you upload a small sample file?
Engineer
Commented:
Try
=countifs(A:A,"<>",B:B,"pass")
Patrick Matthews
Top Expert 2010

Commented:
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

Author

Commented:
Thank-you.
Just what I wanted.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial