=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!
|