Countif(len(Range)4)
 

I am trying to find a simple way to Countif a range where the cell
contents can be either a 2,4 or 6 digit number, or a phone number
including dashes ("123-456-7890"). I want to count only the full 10
digit phone numbers.

Example:

22
32
4453
222333
123-456-7890
234-567-8901
23
4450
4449
222332


Result should be "2" as there are two full 10 digit phone numbers in
the sample.

It seems that something like =countif(len(a1:a10)6) would describe
what I want. Can anyone tell me if there is a way to use the Length
function in a countif is possible, and if so, how?

Any other ideas?

Thanks,
CortezTK

Countif(len(Range)4)
 

Give this a try:

=SUMPRODUCT(--(LEN(A1:A10)6))

HTH,
Elkar


"Cortez" wrote:

I am trying to find a simple way to Countif a range where the cell
contents can be either a 2,4 or 6 digit number, or a phone number
including dashes ("123-456-7890"). I want to count only the full 10
digit phone numbers.

Example:

22
32
4453
222333
123-456-7890
234-567-8901
23
4450
4449
222332


Result should be "2" as there are two full 10 digit phone numbers in
the sample.

It seems that something like =countif(len(a1:a10)6) would describe
what I want. Can anyone tell me if there is a way to use the Length
function in a countif is possible, and if so, how?

Any other ideas?

Thanks,
CortezTK

Countif(len(Range)4)
 

=Count(Len(A1:A10,12)


"Cortez" wrote in message
oups.com...
I am trying to find a simple way to Countif a range where the cell
contents can be either a 2,4 or 6 digit number, or a phone number
including dashes ("123-456-7890"). I want to count only the full 10
digit phone numbers.

Example:

22
32
4453
222333
123-456-7890
234-567-8901
23
4450
4449
222332


Result should be "2" as there are two full 10 digit phone numbers in
the sample.

It seems that something like =countif(len(a1:a10)6) would describe
what I want. Can anyone tell me if there is a way to use the Length
function in a countif is possible, and if so, how?

Any other ideas?

Thanks,
CortezTK