Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add alternate rows
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks! |
#2
|
|||
|
|||
Teri wrote:
I can't seem to find how to do this. Want to add every other row in a worksheet. Any ideas? Thanks! Do you mean 1,3,5,etc. or 2,4,6,etc.? Alan Beban |
#3
|
|||
|
|||
You got it! Thanks for responding :)
"Alan Beban" wrote: Teri wrote: I can't seem to find how to do this. Want to add every other row in a worksheet. Any ideas? Thanks! Do you mean 1,3,5,etc. or 2,4,6,etc.? Alan Beban |
#4
|
|||
|
|||
=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=0),A1:A20)
will add every even row in column A =SUMPRODUCT(--(MOD(ROW(A1:A20),2)=1),A1:A20) adds every odd row -- HTH RP (remove nothere from the email address if mailing direct) "Teri" wrote in message ... I can't seem to find how to do this. Want to add every other row in a worksheet. Any ideas? Thanks! |
#5
|
|||
|
|||
Let A2:A400 be the range of interest...
=SUMPRODUCT(--(MOD(ROW(A2:A400)-CELL("Row",A2)+0,H2)=0),A2:A400) Teri wrote: I can't seem to find how to do this. Want to add every other row in a worksheet. Any ideas? Thanks! |
#6
|
|||
|
|||
Replace H2 with 2.
Aladin Akyurek wrote: Let A2:A400 be the range of interest... =SUMPRODUCT(--(MOD(ROW(A2:A400)-CELL("Row",A2)+0,H2)=0),A2:A400) Teri wrote: I can't seem to find how to do this. Want to add every other row in a worksheet. Any ideas? Thanks! |
#7
|
|||
|
|||
AWESOME! That was so easy! Thank you!
"Bob Phillips" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A20),2)=0),A1:A20) will add every even row in column A =SUMPRODUCT(--(MOD(ROW(A1:A20),2)=1),A1:A20) adds every odd row -- HTH RP (remove nothere from the email address if mailing direct) "Teri" wrote in message ... I can't seem to find how to do this. Want to add every other row in a worksheet. Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select alternate rows to copy | Excel Discussion (Misc queries) | |||
How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
How to sum-up alternate rows ? | Excel Worksheet Functions | |||
Use of Exact(or other) function for alternate rows? | Excel Worksheet Functions | |||
Identifying exact values in alternate rows | Excel Worksheet Functions |