how do i add every fifth row in a spreadsheet?

G

Guest

Assuming you want to start with row 1, then row 6, row 11, all in column A

=SUMPRODUCT(--(MOD(ROW(A1:A100),5)=1),A1:A100)

If you want to SUM starting with the value in row 2, then use

=SUMPRODUCT(--(MOD(ROW(A2:A100),5)=2),A1:A100)

and so on, up to row 4. If you want to start with row 5, then use

=SUMPRODUCT(--(MOD(ROW(A5:A100),5)=0),A1:A100)
 

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

Conditional formatting 2
add row 3
every fifth line 2
Averaging every 5th cell while omitting zeros 4
Fifth Wednesday 4
Recurrance Pattern-schedule the fifth day of every month? 2
Need additional fields for every fifth report? 5
VLOOKUP using Fifth Column 3

Top