If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|