Formula with { }

  • Thread starter Thread starter Jeff
  • Start date Start date
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))))}
 
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.
 
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
 
Back
Top