Alternate column summation

**martindwilson** · 03-23-2013, 04:50 PM

=SUMPRODUCT((MOD(COLUMN(AK6:HN6),2))*(AK6:HN6)) works

**KoRn** · 03-23-2013, 06:18 PM

I tried it, but it doesn't seem there just yet... I believe these cells (AW6, AY6, BC6, BE6, CI6, CK6, FY6, GA6, GS6, GU6, HK6, HM6) that I want excluded in the summation, are causing the problem. How can I write a formula that excludes these specific cells in the calculation? Thanks for your help

**martindwilson** · 03-23-2013, 06:41 PM

hn6 is not in every other column starting ak6,
but why not just subtract them

=SUMPRODUCT((MOD(COLUMN(AK6:HN6),2))*(AK6:HN6))-SUM(AW6, AY6, BC6, BE6, CI6, CK6, FY6, GA6, GS6, GU6, HK6)