sum every other cell in a large range

[jdbell]

an easy way to sum a large range of cells including every other cell in the range

[#2]

@jdbell 

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

[#3]

Can this formula be extended to multiple columns?

[#4]

@ParkerL940 

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