Sum of alternate columns

[KoRn]

Hi all,

I need an equation that adds alternate columns starting from BA6(BA6, BC6, BE6...IB6 etc) ending IB6.

Excluding columns: BM, BN, NO, BP, BS, BT, BU, BV, DA, DB, DC, DD, GQ, GR, GS, GT, HK, HL, HM, HN, IC, ID, IE, IF As they'll get caught up in the process.

If this is possible please let me know.

Thanks

[Wagstaff]

Hi,

see if this formula works for you

=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

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

Regards