how do i add every fifth row in a spreadsheet?
 

how do i add every fifth row in a spreadsheet?

how do i add every fifth row in a spreadsheet?
 

Starting from which row?

Biff

"skyking" wrote in message
...
how do i add every fifth row in a spreadsheet?

how do i add every fifth row in a spreadsheet?
 

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)

"skyking" wrote:

how do i add every fifth row in a spreadsheet?