Sum of SQRT(x)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
SUMSQ(A1:A10)


Bernard Liengme said:
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
Click to expand...
 
Thanks a lot, your second suggestion did it! I didn't know about the
CTRL+SHIFT+ENTER!
Thanks again.
 
Back
Top