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