adding alternate columns
 

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...

adding alternate columns
 

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.
--
Regards,
Tom Ogilvy


"Mir Khan" wrote in message
...
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...

adding alternate columns
 

=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)



"Mir Khan" wrote in message
...
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...