Sum of alternate columns

Hi,

see if this formula works for you

Formula:

=SUMPRODUCT(MOD( COLUMN($BA$6:$IB$6),2 )*$BA$6:$IB$6)

This will add up all odd columns within the range

To add up even columns use

Formula:

=SUMPRODUCT((1-MOD( COLUMN($BB$6:$IC$6),2 ))*$BB$6:$IC$6)

Regards