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