You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter sjs1968
- Start date

Sorry - I should have explained better. I want to count how many cells contain a 10 digit number not the sum of these cells.Without example or sample sheet ( no pics please)

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

Here is a link with two solutions available to you

This formula does NOT sum the cells with 10 digit-long numbers, itSorry - I should have explained better. I want to count how many cells contain a 10 digit number not the sum of these cells.

Thank you - works a treatThis formula does NOT sum the cells with 10 digit-long numbers, itcountsthem. Have you taken a moment to try it out?

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?Thank you - works a treat

Worked it outThe 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?

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