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
|