If I use <code>COUNTA(range)</code>, it counts cells with the empty string (""). How do I avoid this? <code>COUNTIFS(range,"<>"&"")</code> doesn't seem to work.

For column A, cells A1 through A100 try: <pre class="prettyprint"><code>=SUMPRODUCT(--(A1:A100<>"")) </code></pre>

Excel - Count all non-blank cells, excluding empty string

For column A, cells A1 through A100 try:

=SUMPRODUCT(--(A1:A100<>""))

answered Oct 01 '22 06:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!