How to sum-up alternate rows ?

[lolex]

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


tks. in advance

 

[Paul B]

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

 

[ehntd]

You would need a SUMIF function.

What you would need to do is insert a couple of columns in your sheet.
One of them numbered 1-199 and in the other the formula ISODD. Th
Isodd will return a true or false. Then with the sum if you would us
the SUMIF(column where the isodd formula is;true;column where th
numbers to add are

 

[Govind]

Hi,

Try

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

Regards

Govind