adding alternate columns

[Mir Khan]

hi experts, i need to sum the data in the alternate columns. how would i do
it...like column BL should display sum of columns B, D, F, H, J .... and
Column BM should display sum of C, E, G, I, K ....

can you please help me...

 

[Tom Ogilvy]

for B, D, F ...
BL2: =SUM(IF(MOD(COLUMN($B2:$BK2),2)=0,$B2:$BK2))

for C, E, G . . .
BM2: =SUM(IF(MOD(COLUMN($B2:$BK2),2)=1,$B2:$BK2))

each should be entered with Ctrl+Shift+enter rather than just enter since
these are array formulas.

then select BL2:BM2 and drag fill down the column.

 

[Bob Phillips]

=SUMPRODUCT(--(MOD(COLUMN($B2:$BK2),2)=0),$B2:$BK2)

and

=SUMPRODUCT(--(MOD(COLUMN($B2:$BK2),2)=1),$B2:$BK2)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)