Skip to content
Home
Tutorials
Real-World Examples
Count numeric cells in a range
Update Formula
Parameters
Formula
Range Reference:
range from which you want to count the number of numeric cells
Formula:
=
SUMPRODUCT
(--
ISNUMBER
(
B5:C11
))
=
SUMPRODUCT
(--
ISNUMBER
(B5:C11))