# Can math operations be passed to ranges? [closed] 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 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

Sort by » oldest newest most voted =SUMSQ(A1:A10)
or
=SUMPRODUCT(A1:A10;A1:A10)

more

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

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

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.

@mariosv, my question clearly takes ^2 as an example and asks for general math operations to ranges (last sentence). 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.

more