enter the formula with ctrl + shift & enter, since you want to do this
cell1^2+cell2^2 and so on, you would need to apply it as an array formula
thus the method of entering it
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"twa14" wrote in message
...
If I put numbers 1,2,3,4 in a named range "x' in cells a1,a2,a3,a4 and put
SUM(x) in any other cell I get "10" as output, thus correct answer. If I
change the formula to "SUM(x^2) I get "1" instead of "30". However when I
use
the function wizard by clicking on "fx" at the top of the screen the
wizard
indicates that the correct answer is "30". I press enter and the cell
shows
"1" instead of "30". Does anyone have any ideas??.
Tom Walsh