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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lina" wrote in message
...
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!

SUMSQ(A1:A10)


"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lina" wrote in message
...
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!

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

"JMB" wrote:

SUMSQ(A1:A10)


"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lina" wrote in message
...
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!

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lina" wrote in message
...
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!