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