@Count

  • Thread starter Thread starter MAD
  • Start date Start date
M

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
 
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,"?*")
 
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.
 
Back
Top