Thread: COUNTING
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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