Report thread as spam

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))}

This question was started by Charlie G 9 years ago

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

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))}

This response was posted by JulieD 9 years ago

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

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

>

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))}

This response was posted by Jerry W. Lewis 9 years ago

### Other excel threads