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.