Use the array formula

=SUMPRODUCT(--(MOD(COLUMN(B1:IV1),2)=0),B1:IV1)

by committing it with Ctrl-Shift-Enter


"alien1155" wrote:

Hey there,

I am trying to do something pretty basic, but not having much luck at this
point.

All I need to do is sum every 2nd column of a sheet after A1...So as an
example, A1=name and then I need to sum the values in B1, D1, F1, H1..etc

thanks for any assistance on this basic question.