Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting Age | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |