Add alternate rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!
 
Teri said:
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!
Click to expand...
Do you mean 1,3,5,etc. or 2,4,6,etc.?

Alan Beban
 
=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)
 
Let A2:A400 be the range of interest...

=SUMPRODUCT(--(MOD(ROW(A2:A400)-CELL("Row",A2)+0,H2)=0),A2:A400)
 
Replace H2 with 2.

Aladin said:
Let A2:A400 be the range of interest...

=SUMPRODUCT(--(MOD(ROW(A2:A400)-CELL("Row",A2)+0,H2)=0),A2:A400)
Click to expand...
 
AWESOME! That was so easy! Thank you!

Bob Phillips said:
=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)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting rows. 3
Excel Moving data to sheet2 from sheet1 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Row height 1
hidden rows problem 7
Incrementing Formula by Column Instead of by Row 1
Color alternate rows when after hiding selected rows 5
Function to sum values across rows with certain features 1

Back
Top