<div>
I am not sure but I think you can get rid of *1 for this case<br />
<br />
{=SUM((BQ3:BQ507&lt;&gt;0)*($BH$<wbr />3:$BH$507&gt;<wbr />=BQ3:BQ507<wbr />))}
</div>


I am not sure but I think you can get rid of *1 for this case

{=SUM((BQ3:BQ507<>0)*($BH$3:$BH$507>=BQ3:BQ507))}

<div>
I didn't try the other example...the initial worked fine.<br />
<br />
Now, I just need to get schooled on what an &quot;Array&quot; formula is and I need to use them. &nbsp;Any suggetions?
</div>


I didn't try the other example...the initial worked fine.

Now, I just need to get schooled on what an "Array" formula is and I need to use them.  Any suggetions?

<div>
To understand this start with a small range say<br />
<br />
{=SUM((BQ3:BQ7&lt;&gt;0)*($BH$3:<wbr />$BH$7&gt;=BQ3<wbr />:BQ7))}<br />
<br />
then <br />
<br />
Formulas &gt;&nbsp;Formula auditing &gt;&nbsp;Evaluate formula<br />
<br />
Step through this by clicking the Evaluate button and see how the formula works.
</div>


To understand this start with a small range say

{=SUM((BQ3:BQ7<>0)*($BH$3:$BH$7>=BQ3:BQ7))}

then

Formulas > Formula auditing > Evaluate formula

Step through this by clicking the Evaluate button and see how the formula works.

<div>
Thanks! &nbsp;I am following this. &nbsp;In addition, I found a good article here <a href="http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx" rel="ugc">http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx</a>&nbsp;on how and why we use array formulas.
</div>


Thanks!  I am following this.  In addition, I found a good article here http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx [http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx] on how and why we use array formulas.

<div>
<div class="content wysiwyg-content">
This is a follow up to a previously answered question.<br />
<br />
{=SUM(($BH$3:$BH$507&gt;=BQ3:<wbr />BQ507)*1)}<wbr /><br />
<br />
I am using the above formula to evaluate and compare two columns of numbers.<br />
<br />
Column range BQ3:BQ507 has the ability to contain 0. &nbsp;Is it possible to use the above formula, or something similar, to evaluate only those cells which have a number greater then 0?<br />
<br />
Thanks for your input.
</div>
</div>


This is a follow up to a previously answered question.

{=SUM(($BH$3:$BH$507>=BQ3:BQ507)*1)}

I am using the above formula to evaluate and compare two columns of numbers.

Column range BQ3:BQ507 has the ability to contain 0.  Is it possible to use the above formula, or something similar, to evaluate only those cells which have a number greater then 0?

Thanks for your input.

Selective comparison to count

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