amend formula

[rkharaud]

does anyone know what the curly brackets are and how to amend this
formula as I get an error message
{=SUM((G23:G30-H23:H30)^2)*1000}

 

[T. Valko]

The squiggly braces mean it's an array formula. See this:

http://www.cpearson.com/Excel/ArrayFormulas.aspx

You can do that another way and not have to worry about those braces.

=SUMPRODUCT((G23:G30-H23:H30)^2)*1000