curly brace {}

[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

 

[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

 

[Niek Otten]

Commite the formula with CTRL+SHIFT+ENTER, not just ENTER.
Excel will insert the curly braces.

This is an array formula. For more information, look here:

http://www.cpearson.com/excel/ArrayFormulas.aspx

 

[Bob Umlas]

Or...
http://www.emailoffice.com/excel/arrays-bobumlas.html
I might add!

Bob Umlas
Excel MVP

 

[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 {}