Forum Discussion
error counting text populated cells
I am using the countif and countA functions to count ‘text populated’ cells and noted that the count is actually counting blank cells as well, when I delete the blank cells (using the keyboard delete...
Hi Haytham,
Thanks for this, while I did not know about the zero length string, I feared something like this; at least now that I know what it is I can think of a fix.
Thanks again
Lee
Hi Lee,
Maybe you can deduct COUNTIFS(A1:A10,"<>"&"")
or expand the COUNTIFS to = COUNTIFS(A1:A10,">0",A1:A10, "<>"&"")
Not quite sure on what your exact scenario is...