Skip to content
Home
Tutorials
Real-World Examples
Count cells with values in odd rows
Update Formula
Parameters
Formula
Range Reference:
Formula:
=
SUMPRODUCT
(--(
MOD
(
ROW
(
B5:B11
),2)=1),--(
B5:B11
<>""))
=
SUMPRODUCT
(--(
MOD
(
ROW
(B5:B11),2)=1),--(B5:B11<>""))
