Formula Problems

T

Tim

Hello,

I have a spreadsheet with a long list of formulas doing
the same thing. The formulas all work, unless I simply
click into the cell, and then click out. The formula looks
exactly the same except for one thing, but it no longer
works. Here is how the formula looks before I click into it:

{=SUM(IF('Oct 2004'!S$4:S$293="Mora",IF('Oct
2004'!M$4:M$293<0,1,0),0))}

After I click into it and come out it looks like this:

=SUM(IF('Oct 2004'!S$4:S$293="Mora",IF('Oct
2004'!M$4:M$293<0,1,0),0))

After I click out, Excel no longer show the {} surrounding
the entire formula. Before clicking in the cell shows '1'.
After clicking the cell shows '0'. I do not make any
changes to the formula at all, meerly click in and out of
the cell! I can retype the entire formula and it will not
work, I have to click Undo, or I'm screwed.

Does anyone know what the {} signifies, and how do I get
this to reappear after editing the cell?

Thanks for your help

Tim
 
D

Don Guillett

The {} indicates an array formula which must be entered/edited with
ctrl+shift+enter.
 
Top