Sum Every Second Row

The formulas in the following examples return a sum of every second row in a range of cells. In the first example, the summing starts with the first row, whereas the summing in the second example starts with the second row.

Starting With the First Row

Sum of Every Second Row, Starting With the First Row

The following formula returns the sum of every second row in A2:A10, starting with the first row...

=SUMPRODUCT(--(MOD(ROW(A2:A10)-ROW(A2)+0,2)=0),A2:A10)

Based on the sample data, the formula returns 150.

Sample Workbook: Download

Starting With the Second Row

Sum of Every Second Row, Starting With the Second Row

The following formula returns the sum of every second row in A2:A10, starting with the second row...

=SUMPRODUCT(--(MOD(ROW(A2:A10)-ROW(A2)+1,2)=0),A2:A10)

Based on the sample data, the formula returns 220.

Sample Workbook: Download