lolex, try this,
=SUMPRODUCT((MOD(ROW(A1:A199)-CELL("Row",A1:A199)+0,2)=0)*(A1:A199))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003

"lolex" wrote in message
...

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


tks. in advance.


--
lolex
------------------------------------------------------------------------
lolex's Profile:
http://www.excelforum.com/member.php...o&userid=16111
View this thread: http://www.excelforum.com/showthread...hreadid=275577