Ask Your Question
1

Can math operations be passed to ranges? [closed]

asked 2013-04-14 11:18:54 +0200

coolman gravatar image

Let's make an easy example:

I have 10 numbers in A1:A10. I want to sum up their squares: A1^2 + A2^2 + ... + A10^2. Currently I use a separate column that stores the squares and sum up this separate column.

Can I somehow tell Calc to do (pseudocode) =SUM( A1^2 : A10^2 ) directly so that I don't need separate columns?

I use SUM() and squares as an example, but my question is general about all math operations and functions applied to ranges.

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 2015-10-30 08:26:06.145208

2 Answers

Sort by » oldest newest most voted
1

answered 2013-04-14 14:25:17 +0200

m.a.riosv gravatar image

=SUMSQ(A1:A10)
or
=SUMPRODUCT(A1:A10;A1:A10)

edit flag offensive delete link more

Comments

Thanks, but what If I need to sum the cubes (A1^3 + A2^3 + ...)?

coolman gravatar imagecoolman ( 2013-04-16 19:58:34 +0200 )edit

Thanks, but what If I need to sum the cubes (A1^3 + A2^3 + ...)?

coolman gravatar imagecoolman ( 2013-04-16 19:58:37 +0200 )edit

Hi coolman, I think the answer solve your question, you ask for ^2. The use in Ask (as in all forums) is one question, one thread. On other hand what can be good is to have a quick read of the help, to know how the program works and what can be done.

m.a.riosv gravatar imagem.a.riosv ( 2013-04-16 23:11:48 +0200 )edit

=SUMPRODUCT(POWER(A1:A10;3))

m.a.riosv gravatar imagem.a.riosv ( 2013-04-16 23:12:31 +0200 )edit

@mariosv, my question clearly takes ^2 as an example and asks for general math operations to ranges (last sentence).

coolman gravatar imagecoolman ( 2013-04-18 10:28:21 +0200 )edit
1

answered 2013-04-14 20:54:12 +0200

horst gravatar image

You might also use the Function Wizard and the Help built in. Select a function, click next and the click Help-Button to get a description of it.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-04-14 11:18:54 +0200

Seen: 201 times

Last updated: Apr 14 '13