Curly Brackets In Formulas

  • Thread starter Thread starter Charlie G
  • Start date Start date
C

Charlie G

I'm trying to copy formulas from one spreadsheet to another similar to the
one below, but the curly brackets disappear, rendering the formulas
inoperable (in the original document, they compare values in one range of
cells against another, count the cells that match as 1, and adds them up).
Adding the curly brackets manually just converts the cells to text. How do I
make these formulas work in the new document? I'm using Excel 2000. TIA.
~Charie G.

{=SUM(COUNTIF(B5:F5,$B$2:$F$2))}
 
Hi Charlie

the {} indicate that the formula is an array formula which is entered in a
cell using a combination of CONTROL + SHIFT + ENTER rather than just ENTER
so
copy & paste the formula, press F2 and then CONTRL + SHIFT + ENTER
and it should work.

Cheers
JulieD
 
To elaborate slightly, since many newsgroup posts include the curly
brackets: you do not type the curly brackets; Excel supplies them in
recognition that you have array entered the formula per Julie's directions.

Jerry
 
Back
Top