Forum Discussion
sum every other cell in a large range
an easy way to sum a large range of cells including every other cell in the range
Let's say you want to sum cells in B2:B50 in the even-numbered rows 2, 4, ..., 50.
=SUMPRODUCT(B2:B50, --ISEVEN(ROW(B2:B50)))
or
=SUM(IF(ISEVEN(ROW(B2:B50)), B2:B50))
- Can this formula be extended to multiple columns?
If you want to sum values in even-numbered rows in A2:B50
=SUM(IF(ISEVEN(ROW(A2:B50)), A2:B50))
If you want to sum values in even-numbered columns in A2:Z2 (i.e. columns B, D, F, ...)
=SUM(IF(ISEVEN(COLUMN(A2:Z2), A2:Z2))
