Hi, hope my question isn't too dumb:
I want the sum of the square roots of several cells. Writing something like:
SUM(SQRT(A1:A10)) or SUM(SQRT(A1):SQRT(A10)) doesn't work.
The only solution I could think of was to have another column that
calculates SQRT(Ai) and then use SUM on that one. There must be a better way
of doing it though, isn't there??
And while we're at it: Is there a general syntax for SUM(f(A1):f(A10)) where
f is some function and is the same for all cells to be summed?

Thanks in advance!