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" <Teri@discussions.microsoft.com> wrote in message
news:F1C07835-0560-4963-8122-01465368310D@microsoft.com...
> 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" <Teri@discussions.microsoft.com> wrote in message
> news:F1C07835-0560-4963-8122-01465368310D@microsoft.com...
> > I can't seem to find how to do this. Want to add every other row in a
> > worksheet. Any ideas? Thanks!
>
>
>