Count cells with values in odd columns - Parameter Editor | Exceldome

Skip to content

Home
Tutorials
Real-World Examples

Count cells with values in odd columns

Range Reference:

Formula:

=SUMPRODUCT(--(MOD(COLUMN(C5:I5),2)=1),--(C5:I5<>""))

=SUMPRODUCT(--(MOD(COLUMN(C5:I5),2)=1),--(C5:I5<>""))

Home | Tutorials | Real-World Examples | About Us | Contact Us | Terms and Conditions Copyright © 2018-2022 Exceldome. - All Rights Reserved