Hi,

Try

=SUMPRODUCT((A1:A200)*(MOD(ROW(A1:A200),2)<0))

Regards

Govind

lolex wrote:

How can I sum-up cells A1,A3,A5,A7..........A199 by using the SUM
function ?


tks. in advance.