How to sum-up alternate rows ?

L

lolex

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


tks. in advance
 
P

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
 
E

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
 
Top