Something like this may work for you:

=SUMPRODUCT(--(MOD(COLUMN(A1:K1),2)=0),A1:K1)
or
=SUMPRODUCT(--(MOD(COLUMN(A1:K1),2)=1),A1:K1)

(first formula gives even numbered columns, second gives odd numbered columns)

JC wrote:

I have a large table where I would like to get the sum of
every other column. My current method is to use the +
key and click on every other cell.

Is there a better way?

Thanks,
JC

--

Dave Peterson