How do I sum a figure derived from a row of cells

Start with a row of numbers. "x"

I wish to calculate the sum of the results of an operation applied to the numbers - for example, sum the squares of the numbers. "f(x)"

Is it possible to combine the summation with the operation without having a separate cell showing "f(x)"?

i.e. sum(f(A1):f(A21))





There are 2 comments. Login or register to view them.

For squares

ACDWebb |
ACDWebb's picture

Or SUMPRODUCT() on its own

shurst |
shurst's picture