COUNTING
 

I have research Help and online. I've done a pile of reading and
experimenting, but nothing works. I know it's got to be simple, but finding
the answer hasn't been!! I have a column of numbers and text. Some cells
have numbers and some cells have one word or two words. Some numbers start
with a zero. Therefore, the whole column is formatted as "text". Each cell
represents a customer's purchase order (PO). Some PO numbers are names
rather than numbers. Some start with zero. Hence the reason for the mixed
data. I'm trying to come up with a formula that will count the number of POs
from that mixed up column. Each row is a new PO. What formula do I use?
Connie

COUNTING
 

=COUNTA(A:A)

"Connie Martin" wrote:

I have research Help and online. I've done a pile of reading and
experimenting, but nothing works. I know it's got to be simple, but finding
the answer hasn't been!! I have a column of numbers and text. Some cells
have numbers and some cells have one word or two words. Some numbers start
with a zero. Therefore, the whole column is formatted as "text". Each cell
represents a customer's purchase order (PO). Some PO numbers are names
rather than numbers. Some start with zero. Hence the reason for the mixed
data. I'm trying to come up with a formula that will count the number of POs
from that mixed up column. Each row is a new PO. What formula do I use?
Connie

COUNTING
 

Have you tried COUNTA()

"Connie Martin" wrote:

I have research Help and online. I've done a pile of reading and
experimenting, but nothing works. I know it's got to be simple, but finding
the answer hasn't been!! I have a column of numbers and text. Some cells
have numbers and some cells have one word or two words. Some numbers start
with a zero. Therefore, the whole column is formatted as "text". Each cell
represents a customer's purchase order (PO). Some PO numbers are names
rather than numbers. Some start with zero. Hence the reason for the mixed
data. I'm trying to come up with a formula that will count the number of POs
from that mixed up column. Each row is a new PO. What formula do I use?
Connie

COUNTING
 

=COUNTA(A:A)

Will count all non-empty cells, whether they contain text, numbers or
formula blanks.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
I have research Help and online. I've done a pile of reading and
experimenting, but nothing works. I know it's got to be simple, but
finding
the answer hasn't been!! I have a column of numbers and text. Some cells
have numbers and some cells have one word or two words. Some numbers
start
with a zero. Therefore, the whole column is formatted as "text". Each
cell
represents a customer's purchase order (PO). Some PO numbers are names
rather than numbers. Some start with zero. Hence the reason for the
mixed
data. I'm trying to come up with a formula that will count the number of
POs
from that mixed up column. Each row is a new PO. What formula do I use?
Connie

COUNTING
 

=COUNTA(range)
like
=COUNTA(A1:A100)

"Connie Martin" wrote in message
...
I have research Help and online. I've done a pile of reading and
experimenting, but nothing works. I know it's got to be simple, but
finding
the answer hasn't been!! I have a column of numbers and text. Some cells
have numbers and some cells have one word or two words. Some numbers
start
with a zero. Therefore, the whole column is formatted as "text". Each
cell
represents a customer's purchase order (PO). Some PO numbers are names
rather than numbers. Some start with zero. Hence the reason for the
mixed
data. I'm trying to come up with a formula that will count the number of
POs
from that mixed up column. Each row is a new PO. What formula do I use?
Connie