Skip to content
Home
Tutorials
Real-World Examples
Count cells that contain odd numbers
Update Formula
Parameters
Formula
Range Reference:
Formula:
=
SUMPRODUCT
(--(
MOD
(
B5:B9
,2)=1))
=
SUMPRODUCT
(--(
MOD
(B5:B9,2)=1))