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

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

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