<div>
It counts any cell that has a value other than &quot;&quot;.
</div>


It counts any cell that has a value other than "".

<div>
Correction - any cell other than a blank cell, as you originally thought - it will ignore cells with &quot;&quot;&nbsp;as the result of a formula.
</div>


Correction - any cell other than a blank cell, as you originally thought - it will ignore cells with "" as the result of a formula.

<div>
You might also consider using COUNTA:<br />
<br />
COUNTA(Bills_New!$M$8:$BQ$<wbr />20)
</div>


You might also consider using COUNTA:

COUNTA(Bills_New!$M$8:$BQ$20)

<div>
<div class="content wysiwyg-content">
I have the following formuila in a spreadsheet:<br />
<br />
COUNTIF(Bills_New!$M$8:$BQ<wbr />$20,&quot;&lt;&gt;&quot;&amp;&quot;<wbr />&quot;)<br />
<br />
Am I right that it is saying that it will count anythng in the range if the cell is not blank? &nbsp;I am not sure what &lt;&gt;&nbsp;actually says. &nbsp;Please explain.<br />
Thanks, David
</div>
</div>


I have the following formuila in a spreadsheet:

COUNTIF(Bills_New!$M$8:$BQ$20,"<>"&"")

Am I right that it is saying that it will count anythng in the range if the cell is not blank?  I am not sure what <> actually says.  Please explain.
Thanks, David

Formula Help With Countif

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