Ask Your Question
0

How to sum only even or odd rows in Calc? [closed]

asked 2014-09-10 11:23:17 +0200

officeer gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 17:35:03.606150

1 Answer

Sort by » oldest newest most voted
1

answered 2014-09-10 13:18:01 +0200

JPL gravatar image

=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

edit flag offensive delete link more

Comments

1

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

JohnSUN gravatar imageJohnSUN ( 2014-09-10 14:21:44 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-09-10 11:23:17 +0200

Seen: 2,730 times

Last updated: Sep 10 '14