counting cell containing only numbers

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
Hi all,



Is there a formula to count only cells containing any numbers in general? Moreover, is there a formula to count values containing an specific number of digits?

Much appreciated
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
=COUNT(range)
 
Top