View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cortez Cortez is offline
external usenet poster
 
Posts: 38
Default 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