Sum of SQRT(x)

[Guest]

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!

 

[Bernard Liengme]

Use =SUMPRODUCT(SQRT(A1:A10)) with simple ENTER

Or =SUM(SQRT(A1:A3)) completed with CTRL+SHIFT+ENTER since it is an array
formula
best wishes

 

[Guest]

SUMSQ(A1:A10)

Use =SUMPRODUCT(SQRT(A1:A10)) with simple ENTER

Or =SUM(SQRT(A1:A3)) completed with CTRL+SHIFT+ENTER since it is an array
formula
best wishes

 

[Guest]

Please disregard - I read sum of square roots, but my brain heard sum of
squares.

 

[Guest]

Thanks a lot, your second suggestion did it! I didn't know about the
CTRL+SHIFT+ENTER!
Thanks again.