Excel formulas and the relevance of this {
 

Help,
I have a frustrating problem in Excel.

I'm making some changes to the formula below within an existing
spreadsheet.

{=SUM((Data_Account=$A5)*(Data_CloseDate<"open")* (Data_Type="Put")*(Data_RO<"Y")*Data_OverallProfi tLoss)}

Now when I make any changes to the forumla, Excel removes the { and }
from each end, then enters the result as 0. Yet when you click on the
'Edit formula' it shows the result within this popup window as the
correct value (i.e. not 0)

I tried adding the { } back into the forumla, but this just changes
the text to a string.

Any ideas ?

Excel formulas and the relevance of this {
 

Paul

that formula was "array entered". You need to press Ctrl-Shift-Enter rather
than just Enter.

Regards

Trevor


"Paul Hollands" wrote in message
om...
Help,
I have a frustrating problem in Excel.

I'm making some changes to the formula below within an existing
spreadsheet.

{=SUM((Data_Account=$A5)*(Data_CloseDate<"open")* (Data_Type="Put")*(Data_RO<"Y")*Data_OverallProfi tLoss)}

Now when I make any changes to the forumla, Excel removes the { and }
from each end, then enters the result as 0. Yet when you click on the
'Edit formula' it shows the result within this popup window as the
correct value (i.e. not 0)

I tried adding the { } back into the forumla, but this just changes
the text to a string.

Any ideas ?

Excel formulas and the relevance of this {
 

When you are finished editing the formula hit

Shift + Ctrl + Enter

HTH

"Paul Hollands" wrote:

Help,
I have a frustrating problem in Excel.

I'm making some changes to the formula below within an existing
spreadsheet.

{=SUM((Data_Account=$A5)*(Data_CloseDate<"open")* (Data_Type="Put")*(Data_RO<"Y")*Data_OverallProfi tLoss)}

Now when I make any changes to the forumla, Excel removes the { and }
from each end, then enters the result as 0. Yet when you click on the
'Edit formula' it shows the result within this popup window as the
correct value (i.e. not 0)

I tried adding the { } back into the forumla, but this just changes
the text to a string.

Any ideas ?

Excel formulas and the relevance of this {
 

Thankyou both so much, you are both 100% correct.

Seems so simple now.

Thanks again

Paul

Excel formulas and the relevance of this {
 

You're welcome ... it's not something you come across every day. Lot's of
things are simple when you know how ... they can be very hard until you do.

Regards


wrote in message
oups.com...
Thankyou both so much, you are both 100% correct.

Seems so simple now.

Thanks again

Paul