Excel formulas and the relevance of this >>> {

[Paul Hollands]

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

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 ?

 

[Trevor Shuttleworth]

Paul

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

Regards

Trevor

 

[Guest]

When you are finished editing the formula hit

Shift + Ctrl + Enter

HTH

 

[hollands_paul]

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

Seems so simple now.

Thanks again

Paul

 

[Trevor Shuttleworth]

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