Even rows: =SUMPRODUCT(--(MOD(ROW(B1:B30),2)=0),B1:B30)
Odd rows; =SUMPRODUCT(--(MOD(ROW(B1:B30),2)=1),B1:B30)

--

HTH

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


"KRM" wrote in message
...
how may I devise a formula for adding only alternate cells in columns?