Curly Brackets In Formulas

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

JulieD

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
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top