Hi Simplefi

This is a array formula
You must use Ctrl-Shift-Enter

See
http://www.cpearson.com/excel/array.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Simplefi" wrote in message ...
HI,
I have a formual
{=sum(if.......)}

when I try to edit the formula, the { } disapear and the formula no longer
works.
If I type these characters in, it still does not work.
What do they ( { } )mean ?