@Count
 

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

@Count
 

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

--
Biff
Microsoft Excel MVP


"MAD" wrote in message
...
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

@Count
 

Try this to count ONLY text in your range

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MAD" wrote in message
...
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

@Count
 

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.

"MAD" wrote:

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