<div>
Can you upload a small sample file?
</div>


<div>
Another alternative would be a PivotTable, using count as the aggregation method.<br />
<br />
The nice thing about a PivotTable is that it allows you to get the counts for all of your combinations.
</div>


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.

<div>
Thank-you. <br />
Just what I wanted.
</div>


<div>
<div class="content wysiwyg-content">
In excel I am trying to calculate a number of tests that have passed (but only if they have a relevant test step). &nbsp;IE- a count function based on two columns.<br />
<br />
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)<br />
<br />
&nbsp;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<br />
<br />
any ideas?
</div>
</div>


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?

Excel formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.