Hi Faisal,

Try this

=SUM((A1:A1000)*(MOD(ROW(INDIRECT("1:1000")),2)=0) )

it is an array formula, so commit with Ctrl-Shift-Delete

--
HTH

Bob Phillips

"Faisal Yameen" wrote in message
...
I want to sum only even cells from A1: A1000
I used =a2+a4+a6+a8+......+a1000
Used this formula n cell b1
But now I want to solve this problem by some short formula
Help me thank you