Prev: What is the most straightforward (elegant) way to write this formu
Next: conditional formatting?
From: MAD on 7 Apr 2010 13:51
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
From: T. Valko on 7 Apr 2010 14:09
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" <MAD(a)discussions.microsoft.com> wrote in message
news:8723996D-BE13-48B6-86E2-2D75F23F07FE(a)microsoft.com...
>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


From: Don Guillett on 7 Apr 2010 14:13
Try this to count ONLY text in your range

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"MAD" <MAD(a)discussions.microsoft.com> wrote in message
news:8723996D-BE13-48B6-86E2-2D75F23F07FE(a)microsoft.com...
>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

From: JLatham on 7 Apr 2010 14:48
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
 | 
Pages: 1
Prev: What is the most straightforward (elegant) way to write this formu
Next: conditional formatting?