how do i add every fifth row in a spreadsheet?

D

Duke Carey

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)
 
Top