Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SUM Every Other Column
Hi,
Can someone please help me with a formula that sums numbers from every other column i.e. B1, D1, F1...etc? -- tarig |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SUM Every Other Column
For row 1:
=SUMPRODUCT(--(MOD(COLUMN(1:1),2)=0),1:1) Change the range "1:1" to something smaller in both callouts if you desire a smaller range. If you want the odd columns (A, C, etc) change the "=0" to "=1". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tarig" wrote: Hi, Can someone please help me with a formula that sums numbers from every other column i.e. B1, D1, F1...etc? -- tarig |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SUM Every Other Column
But full column/row reference such as A:A or 1:1 are permit in SUMPRODUCT
only in Excel 2007 and 2010. In earlier versions you would need ranges =SUMPRODUCT(--(MOD(COLUMN(A1:Z1),2)=0),A1:Z1) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Luke M" wrote in message ... For row 1: =SUMPRODUCT(--(MOD(COLUMN(1:1),2)=0),1:1) Change the range "1:1" to something smaller in both callouts if you desire a smaller range. If you want the odd columns (A, C, etc) change the "=0" to "=1". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tarig" wrote: Hi, Can someone please help me with a formula that sums numbers from every other column i.e. B1, D1, F1...etc? -- tarig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) |