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

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" <(E-Mail Removed)> wrote in message
news:BC418BAB-3148-469D-84BE-(E-Mail Removed)...
> 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...

=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" <(E-Mail Removed)> wrote in message
news:BC418BAB-3148-469D-84BE-(E-Mail Removed)...
> 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...