<div>
The regular COUNT function doesn't count errors, so this would be just as effective...<br />
<br />
&nbsp; &nbsp; =COUNT($M$2:$M$23)<br />
<br />
If you are counting Text values and needing to use COUNTA we'd need to look at other options, but I'd use COUNTIFS instead of a SUMPRODUCT formula...<br />
<br />
=COUNTIFS($M$2:$M$23, &quot;&lt;&gt;#N/A&quot;, $M$2:$M$23, &quot;&lt;&gt;#DIV/0!&quot;, $M$2:$M$23, &quot;&lt;&gt;&quot;, $M$2:$M$23, &quot;&lt;&gt;&nbsp;&quot;)
</div>


The regular COUNT function doesn't count errors, so this would be just as effective...

    =COUNT($M$2:$M$23)

If you are counting Text values and needing to use COUNTA we'd need to look at other options, but I'd use COUNTIFS instead of a SUMPRODUCT formula...

=COUNTIFS($M$2:$M$23, "<>#N/A", $M$2:$M$23, "<>#DIV/0!", $M$2:$M$23, "<>", $M$2:$M$23, "<> ")

Medicine

Flora Edwards

<div>
<div class="content wysiwyg-content">
I have this formula<br />
<br />
=SUMPRODUCT((1-ISERROR($M$<wbr />2:$M$23))/<wbr />COUNTIF($M<wbr />$2:$M$23,$<wbr />M$2:$M$23&amp;<wbr />&quot;&quot;))<br />
<br />
it excludes the count those cell that has Errors.<br />
<br />
I want include two more conditions that do not count if the cell is empty and do not count If the cell has text which is simply a space &nbsp;like this &nbsp;&quot; &quot;
</div>
</div>


I have this formula

=SUMPRODUCT((1-ISERROR($M$2:$M$23))/COUNTIF($M$2:$M$23,$M$2:$M$23&""))

it excludes the count those cell that has Errors.

I want include two more conditions that do not count if the cell is empty and do not count If the cell has text which is simply a space  like this  " "

How to modify the count 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 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.