Sum offset formula to add every other column

[Jana]

What formula can I use to sum every other column in the
same row? I know it's a sum(offset) formula, but can't
remember how to do it. EXAMPLE: Want formula in A1 to be
sum of C,E,G,I and sum in B1 to be sum of D,F,H,J - will
continue for many columns that's why I don't want to just
add each cell using +.

A B C D E F G H I J
1 57 62 20 15 17 25 5 10 15 12

 

[Frank Kabel]

Hi
in A1 enter:
=SUM(C:C,E:E,G:G,I:I)
and copy to the left

 

[Jana]

Not quite what I wanted. I was trying to avoid doing a
formula that summed each cell because eventually the
spreadsheet will go out to column DD and the formula will
result in an error from too many entries. I wanted
somekind of sumoffset formula that would add every other
column in a row. Something like sum(offset(C1D1,?,?)),
but I can't remember what to put in to tell it to sum
every other column.
Thanks,
Jana

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(MOD(COLUMN(A1D1),2)=1),A1D1)

to sum A1,C1,E1,..

or
=SUMPRODUCT(--(MOD(COLUMN(A1D1),2)=0),A1D1)
to sum B1, D1, F1, ...

 

[RagDyeR]

Try this:

In A1 enter:

=SUMPRODUCT((MOD(COLUMN(C1D1)+1,2)=0)*(C1D1))

And, in B1 enter:

=SUMPRODUCT((MOD(COLUMN(D1D1)+2,2)=0)*(D1D1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Not quite what I wanted. I was trying to avoid doing a
formula that summed each cell because eventually the
spreadsheet will go out to column DD and the formula will
result in an error from too many entries. I wanted
somekind of sumoffset formula that would add every other
column in a row. Something like sum(offset(C1D1,?,?)),
but I can't remember what to put in to tell it to sum
every other column.
Thanks,
Jana