Loading
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