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