Nov 05 2023 10:48 AM
an easy way to sum a large range of cells including every other cell in the range
Nov 05 2023 11:32 AM
@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))
