As we all know, the sum function can help us easily get the sum of a row or column, or even an area. But on special occasions, we need to sum up every other row in Excel. So, this is today’s point, how to sum every other row in Excel?

Let’s take an example. Here we are going to sum the odd rows.

Type =SUMPRODUCT((MOD(ROW(A1:G10),2)=1)*A1:G10) in cell J12, and press Enter key.

Here we got the sum of every odd row.

You can check the correction of the result in the most direct way. just take the sum of each row and then add the odd rows.

How about summing the even rows? Just take place the 1 into 0.

=SUMPRODUCT((MOD(ROW(A1:G10),2)=1)*A1:G10)

Hope this can be helpful to you. See you guys next time.