Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing Alternate Rows
We have spreadsheets with many rows and need to sum alternate rows. Is there a way to do this without entering a formula using the number of each row? -- KarenQ ------------------------------------------------------------------------ KarenQ's Profile: http://www.excelforum.com/member.php...o&userid=19608 View this thread: http://www.excelforum.com/showthread...hreadid=395115 |
#2
|
|||
|
|||
Try this: =SUMPRODUCT(--(MOD(ROW($A$1:$A$18),2)=1),$A$1:$A$18) That formula sums odd-row values in the range A1:A18. To sum even-row values the formula is: =SUMPRODUCT(--(MOD(ROW($A$1:$A$18),2)=0),$A$1:$A$18) Adjust the ranges as necessary. Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=395115 |
#3
|
|||
|
|||
Thanks so much!! That was so easy. I figured there had to be a simple solution. -- KarenQ ------------------------------------------------------------------------ KarenQ's Profile: http://www.excelforum.com/member.php...o&userid=19608 View this thread: http://www.excelforum.com/showthread...hreadid=395115 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to highlight alternate rows | New Users to Excel | |||
moving alternate rows | Excel Discussion (Misc queries) | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | 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 |