Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Adding Rows to Master Sheet | New Users to Excel | |||
How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
Use of Exact(or other) function for alternate rows? | Excel Worksheet Functions | |||
Identifying exact values in alternate rows | Excel Worksheet Functions |