Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM alternate columns | Excel Discussion (Misc queries) | |||
print 4 alternate columns | New Users to Excel | |||
Adding alternate columns | Excel Discussion (Misc queries) | |||
Alternate shading based on series of numbers in 3 columns | Excel Programming | |||
Sum alternate columns over a large (>100) range | Excel Discussion (Misc queries) |