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)