countif?

[Vegs]

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

[Vito]

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

[David Billigmeier]

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.

[Pats]

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]

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.

[Vegs]

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.

[Gord Dibben]

Vegs

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


Gord Dibben Excel MVP

On Mon, 19 Dec 2005 10:56:02 -0800, "Vegs" <[email protected]>
wrote:

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