amend formula
 

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}

amend formula
 

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

--
Biff
Microsoft Excel MVP


wrote in message
...
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}