Counting Cells With Text
Thanks guys. All three solutions worked as you said.
Harlan: Using =COUNTIF(range,"*") was especially helpful because it counted
both the text cells and the "" or null cells, which is what I needed. That
is, it counted them in the simple COUNTIF version. Using COUNTIFS, however,
produced a different result because I must put the equals inside the quotes.
Here is the actual formula:
=COUNTIFS($D$2:$D$1600,AE1,$K$2:$K$1600,"0",$N$2: $N$1600,"=*")
In this instance, it only counts the text cells and not the "" or null
cells. My workaround is to also use
=COUNTIFS($D$2:$D$1600,AE1,$K$2:$K$1600,"0",$N$2: $N$1600,"")
and add them together.
Unless you know a better way... :)
Thanks again.
Peace
_________________________________________
"Harlan Grove" wrote:
Mike H wrote...
Try this
=COUNTA(A1:A6)-COUNT(A1:A6)
....
This counts all entries except numbers, which means it'd count boolean
and error values in addition to text.
Simplest way to count cells containing text is
=COUNTIF(range,"*")
which would include nonblank cells evaluating to "". To count only
text with one or more characters, use
=COUNTIF(range,"?*")
|