@Count

[MAD]

I am using Excel 2003.
How do I count rows/column with only text in it. Ex: I have 25 rows where
column "B" says "PO Received" in each cell. I tried @count(B1-B24), but I
only came up with "0" as an answer. What am I doing wrong? Can anyone help
me with this, please???

Aurora

 

[T. Valko]

In Excel formulas are started with an equal = sign.

If you start with the "at" sign Excel will change it to the equal sign.

To count *text only* :

=COUNTIF(B1:B24,"*")

That will include cells that contain formula blanks "". To exclude cells
that contain formula blanks:

=COUNTIF(B1:B24,"?*")

 

[Don Guillett]

Try this to count ONLY text in your range

=SUMPRODUCT((ISTEXT(B1:B24)*1))

 

[JLatham]

COUNTA() counts both text and numbers
COUNT() counts only numbers, so

=Counta(B1:B24)-Count(B1:B24)
will give you the number of text entries in the range B1:B24

You could also use
=COUNTIF(B1:B24,"PO Received")
and that would count only cells in the range with those words in them.