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