•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
Tagged with
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#financial modeling with spreadsheets
#excel
#formula
#count
#cells
#numbers
#letters
#ISNUMBER
#SUMPRODUCT
#product codes
#text
#formatting
#recognize
#auto count
#range
#submitted by