Ask Your Question
0

In Calc, is it possible to calculate the sum of a function without creating an auxiliary column?

asked 2018-09-07 13:04:38 +0200

Erel Segal-Halevi gravatar image

Suppose I have some numbers in cells A1,...,A99. I want to calculate the sum of their cubes, i.e., A1^3 + A2^3 + ... + A99^3. One option is to create the cubes in column B, so that B1 = A1^3, B2=A2^3, etc., and then calculate SUM(B1:B99).

My question is: can I make the same calculation without using an extra column? I mean a command such as: SUM(x=A1:A99, x^3)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-09-07 13:13:58 +0200

=SUMPRODUCT(A1:A99^3)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-07 13:04:38 +0200

Seen: 37 times

Last updated: Sep 07 '18