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.
=SUMSQ(A1:A10)
or
=SUMPRODUCT(A1:A10;A1:A10)
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.
=SUMPRODUCT(POWER(A1:A10;3))
@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.