Forum Discussion
jdbell
Nov 05, 2023Copper Contributor
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
3 Replies
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))
- ParkerL940Copper ContributorCan 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))