•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Count number of cells that contain numbers and no letters
Trying to build a formula that will count the number of cells that contain only numbers and no letters. My issue is excel doesn't seem to recognize the cells as numbers & fornatting may mess them up because they're product codes and some start with 0. so some cells are like 0123456 and some are like A12345 and I want a formula to auto count the cells without the A.
Doesn't work: =SUMPRODUCT(--ISNUMBER(range))
Doing =isnumber comes back false on the cells that are like 012345 because they are recognized as text.
[link] [comments]
Want to read more?
Check out the full article on the original site