V
Vegs
I need to count numbered text, such as, "100A" in a column.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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().
to count the total number of populated cells (numerical values and text
values) use =COUNTA().
P
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.
1201
Then I used =COUNTIF(A1:A3,"100A") and it returned 1, which is correct.
V
Vito
=countif(a:a,"100a")
V
Vegs
Thanks Dave...
I needed to add "*100A*" to the COUNTIF fucntion.
I needed to add "*100A*" to the COUNTIF fucntion.
V
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..
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..
G
Gord Dibben
Vegs
=countif(A:A, "100A")
Gord Dibben Excel MVP
=countif(A:A, "100A")
Gord Dibben Excel MVP