How to sum-up alternate rows ?
 

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

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

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. The
Isodd will return a true or false. Then with the sum if you would use
the SUMIF(column where the isodd formula is;true;column where the
numbers to add are)


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

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.