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!