Assuming column A holds them like this: 123-45-6789
=SUMPRODUCT(--(LEN(A1:A100)=11),--(NOT(ISERROR(VALUE(LEFT(A1:A100,3))))),--(NOT(ISERROR(VALUE(MID(A1:A100,5,2))))),--(NOT(ISERROR(VALUE(RIGHT(A1:A100,4))))),--(MID(A1:A100,4,1)="-"),--(MID(A1:A100,7,1)="-"))
This will total all that pass the test that the entire entry is 11
characters, the first three characters are numbers, the two in the middle are
numbers, the four on the end are numbers, the fourth character is the dash
and the seventh character is the dash. It won't work if you try to count an
entire column at once, so edit the A1:A100 part to suit your needs, but don't
use A:A. If you've using a format other than 123-45-6789, post a sample, and
we can adjust from there.
