How to sum only even or odd rows in Calc?

[officeer]

How to sum only even or odd rows?

example:

1 0.5
2 0.3
3 1
4 7
5 8.3
6 14

How to sum only rows 2, 4, and 6 without specifically selecting them?

[JPLED]

=SUMPRODUCT(A1:A6;MOD(ROW(A1:A6);2)=0)

if A1:A6 is the range where the values to sum up are stored.

If the values are stored horizontally, use COLUMN i.o. ROW.

JPL

[JohnSUN]

MOD(ROW(A1:A6);2)=0 equal ISEVEN(ROW(A1:A6)), So, =SUMPRODUCT(A1:A6;ISEVEN(ROW(A1:A6)))