I need to count numbered text, such as, "100A" 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,
Dave


"Vegs" wrote:

I need to count numbered text, such as, "100A" in a column.

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

"Vegs" wrote:

I need to count numbered text, such as, "100A" in a column.

=countif(a:a,"100a")


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=494665

Thanks Dave...
I needed to add "*100A*" to the COUNTIF fucntion.

"David Billigmeier" wrote:

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,
Dave


"Vegs" wrote:

I need to count numbered text, such as, "100A" in a column.

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

"Pats" wrote:

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

"Vegs" wrote:

I need to count numbered text, such as, "100A" in a column.

Vegs

=countif(A:A, "100A")


Gord Dibben Excel MVP

On Mon, 19 Dec 2005 10:56:02 -0800, "Vegs"
wrote:

I need to count numbered text, such as, "100A" in a column.