# curly brace {}

K

#### Karl Townsend

I have formula out of a very old worksheet that I'm trying to re use in a
new worksheet

=SUM(IF(LEDGER!\$B\$5:\$B\$999=+\$B9,LEDGER!\$F\$5:\$F\$999))

This is the formula in the old worksheet, EXCEPT it has curly braces {}
around it

{=SUM(IF(LEDGER!\$B\$5:\$B\$999=+\$B9,LEDGER!\$F\$5:\$F\$999))}

How do you insert these braces??? You can't just type them. Also, if you
<F2> <enter> you lose them in the old worksheet. This formula does not work
with the {} removed.

FWIW this formula does a conditional sum on the data in a general ledger.

Karl

B

#### Bernard Liengme

You do not inset the braces, Excel does
You need to learn about array formulas: visit Chip's site
http://www.cpearson.com/excel/ArrayFormulas.aspx
When you have typed (or edited) an array formula you do not just hit the
Enter key but use CTRL+SHIFT+ENTER. At that point Excel add the braces.
best wishes

N

S

#### Shane Devenshire

Hi,

And a minor change to the formula

=SUM(IF(LEDGER!\$B\$5:\$B\$999=\$B9,LEDGER!\$F\$5:\$F\$999))
(I took out the + sign)

and actually this is not the best formula:

=SUMIF(LEDGER!\$B\$5:\$B\$999,\$B9,LEDGER!\$F\$5:\$F\$999)

And this formula is not an array and probably runs faster than an array.

If this helps please click the Yes button.

Cheers,
Shane Devenshire

#### Mekail

How I can give input in excel of following information. I can't find {}

#### Attachments

• 204.3 KB Views: 11