Add alternate rows
 

I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!

Teri wrote:
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!
Do you mean 1,3,5,etc. or 2,4,6,etc.?

Alan Beban

You got it! Thanks for responding :)

"Alan Beban" wrote:

Teri wrote:
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!
Do you mean 1,3,5,etc. or 2,4,6,etc.?

Alan Beban

=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=0),A1:A20)

will add every even row in column A

=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=1),A1:A20)

adds every odd row

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Teri" wrote in message
...
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!

Let A2:A400 be the range of interest...

=SUMPRODUCT(--(MOD(ROW(A2:A400)-CELL("Row",A2)+0,H2)=0),A2:A400)

Teri wrote:
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!

Replace H2 with 2.

Aladin Akyurek wrote:
Let A2:A400 be the range of interest...

=SUMPRODUCT(--(MOD(ROW(A2:A400)-CELL("Row",A2)+0,H2)=0),A2:A400)

Teri wrote:

I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!

AWESOME! That was so easy! Thank you!

"Bob Phillips" wrote:

=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=0),A1:A20)

will add every even row in column A

=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=1),A1:A20)

adds every odd row

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Teri" wrote in message
...
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!