software

I need to count numbered text, such as, quot;100Aquot; in a column.

If you need to count the number of numerical values use =COUNT(), if you need
to count the total number of populated cells (numerical values and text
values) use =COUNTA().--
Regards,
Davequot;Vegsquot; wrote:

gt; I need to count numbered text, such as, quot;100Aquot; in a column.

I created a workbook and entered some dummy text values, such as 100A, 110A,
1201
Then I used =COUNTIF(A1:A3,quot;100Aquot;) and it returned 1, which is correct.

quot;Vegsquot; wrote:

gt; I need to count numbered text, such as, quot;100Aquot; in a column.


=countif(a:a,quot;100aquot;)--
Vito
------------------------------------------------------------------------
Vito's Profile: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=494665Thanks Dave...
I needed to add quot;*100A*quot; to the COUNTIF fucntion.

quot;David Billigmeierquot; wrote:

gt; If you need to count the number of numerical values use =COUNT(), if you need
gt; to count the total number of populated cells (numerical values and text
gt; values) use =COUNTA().
gt;
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;Vegsquot; wrote:
gt;
gt; gt; I need to count numbered text, such as, quot;100Aquot; in a column.

Thanks Pats,
The spreadsheet was generated from another program so the values weren't
centered in the cell...I added asterisks quot;*100A*quot; to the formula and it
works..

quot;Patsquot; wrote:

gt; I created a workbook and entered some dummy text values, such as 100A, 110A,
gt; 1201
gt; Then I used =COUNTIF(A1:A3,quot;100Aquot;) and it returned 1, which is correct.
gt;
gt; quot;Vegsquot; wrote:
gt;
gt; gt; I need to count numbered text, such as, quot;100Aquot; in a column.

Vegs

=countif(A:A, quot;100Aquot;)Gord Dibben Excel MVP

On Mon, 19 Dec 2005 10:56:02 -0800, quot;Vegsquot; gt;
wrote:

gt;I need to count numbered text, such as, quot;100Aquot; in a column.