Forum Discussion
Solved
Sum every second cell in a column
Hi, Is there an easy way to sum every second value/cell in a column? I have a column with 1425 rows, and would line to sum every second cell, i.e. every even numbered cell, and also sum every odd n...
- For sum of even-numbered rows, you may use:
=SUMPRODUCT(ISEVEN(ROW(A:A))*A:A)
For odd, just change ISEVEN to ISODD.
