Count number of cells containing a 10 digit number

[sjs1968]

I wish to count the total number of cells in a column that contain a 10 digit number. Can someone help please?

 

[pecoflyer]

Without example or sample sheet ( no pics please)

=sumproduct(--(len(a1:a10)=10))

 

[sjs1968]

Without example or sample sheet ( no pics please)

=sumproduct(--(len(a1:a10)=10))

Sorry - I should have explained better. I want to count how many cells contain a 10 digit number not the sum of these cells.

 

[AlanSidman]

Here is a link with two solutions available to you

 

[vletm]

sjs1968​

One sample solution ...

 

[pecoflyer]

Sorry - I should have explained better. I want to count how many cells contain a 10 digit number not the sum of these cells.

This formula does NOT sum the cells with 10 digit-long numbers, it counts them. Have you taken a moment to try it out?

 

[sjs1968]

This formula does NOT sum the cells with 10 digit-long numbers, it counts them. Have you taken a moment to try it out?

Thank you - works a treat

 

[sjs1968]

Thank you - works a treat

The formula counts all cells with 10 characters. I would like to fine tune this formula to count the number of cells that contain a number AND is 10 digits long. Any ideas please?

 

[sjs1968]

The formula counts all cells with 10 characters. I would like to fine tune this formula to count the number of cells that contain a number AND is 10 digits long. Any ideas please?

Worked it out
=SUMPRODUCT(—(ISNUMBER(A2:A7)),—(LEN(A2:A7)=10))

 

[macropod]

=SUMPRODUCT((A1:A11^0)*(INT(LOG(A1:A11))=9))