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