SUM a named range

T

twa14

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
 
P

Peo Sjoblom

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
 
Top