Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lolex
 
Posts: n/a
Default 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

  #2   Report Post  
Paul B
 
Posts: n/a
Default

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



  #3   Report Post  
ehntd
 
Posts: n/a
Default


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

  #4   Report Post  
Govind
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 08:11 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 11:56 PM
How do I shade alternate rows in Excel 2002? drummergirl73 Excel Discussion (Misc queries) 2 November 29th 04 10:17 PM
Use of Exact(or other) function for alternate rows? yusee_ygs Excel Worksheet Functions 2 November 3rd 04 09:44 PM
Identifying exact values in alternate rows YG Excel Worksheet Functions 1 November 3rd 04 12:25 AM


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"