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
 
Ad

Advertisements

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
 
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
 
Ad

Advertisements

Ad

Advertisements


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

Similar Threads


Top