|
Posted to microsoft.public.excel.newusers
|
|
|
Sum of SQRT(x)
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!
|