Countif(len(Range)>4)

C

Cortez

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top