Formula with { }

J

Jeff

I was given a spreadsheet with the formula below. It has
{ } brackets around the formula when I lok at it in the
cell. If I click on the cell to liek edit the formaul but
do not chnage anythign and exit out. The number
calculated disappears along with the {}. I have to click
undo command to get the number back. I need to copy this
cell and edit it. When I try to copy it and edit it by
adding back the {} it just makes the formula a text
string. Does anyone know what these things are and how I
can fix this? Thanks

{=SUM(IF('Sheet1'!$J$5:$J$38=$B23,IF('Sheet1-NII'!
$K$5:$K$38=D$19,IF('Sheet1'!$A$5:$A$38<$G$1+1,'Sheet1'!
$I$5:$I$38))))+SUM(IF('Sheet2'!$J$5:$J$59=$B23,IF('Sheet2'!
$K$5:$K$59=D$19,IF('Sheet2'!$A$5:$A$59<$G$1+1,'Sheet2'!
$I$5:$I$59))))+SUM(IF('Sheet3'!$J$5:$J$43=$B23,IF('Sheet3'!
$K$5:$K$43=D$19,IF('Sheet3'!$A$5:$A$43<$G$1+1,'Sheet3'!
$I$5:$I$43))))}
 
J

J.E. McGimpsey

it's an array formula, entered by holding down the CTRL and SHIFT
keys when hitting ENTER.

See "About array formulas and how to enter them" in XL Help.
 
G

Gilles Desjardins

Those brackets are inserted BY Excel NOT you. In the following manner: Once
you have finished editing the formula hit Ctrl AND Sfht AND Enter keys this
method creates an ARRAY formula.

HTH

Gilles
 
Top