Conditional Sum Brackets { }
 

I have forgotten how to re-establish the brackets { } at the beginning and
end of a conditional sum formula. They disappear when I modify the formula
and I have forgotten how to re-establish them. Can anyone help me?

Conditional Sum Brackets { }
 

Use the key combination of CTRL,SHIFT,ENTER

Biff

"ron" wrote in message
...
I have forgotten how to re-establish the brackets { } at the beginning and
end of a conditional sum formula. They disappear when I modify the formula
and I have forgotten how to re-establish them. Can anyone help me?

Conditional Sum Brackets { }
 

Sorry. I just remembered. I use ctrl+shft+enter.

"ron" wrote:

I have forgotten how to re-establish the brackets { } at the beginning and
end of a conditional sum formula. They disappear when I modify the formula
and I have forgotten how to re-establish them. Can anyone help me?

Conditional Sum Brackets { }
 

Ron,


You may mean Array formula and its Ctrl+Shift+Enter.

Mike

"ron" wrote:

I have forgotten how to re-establish the brackets { } at the beginning and
end of a conditional sum formula. They disappear when I modify the formula
and I have forgotten how to re-establish them. Can anyone help me?

Conditional Sum Brackets { }
 

Yes. Thanks.

"Mike H" wrote:

Ron,


You may mean Array formula and its Ctrl+Shift+Enter.

Mike

"ron" wrote:

I have forgotten how to re-establish the brackets { } at the beginning and
end of a conditional sum formula. They disappear when I modify the formula
and I have forgotten how to re-establish them. Can anyone help me?

Conditional Sum Brackets { }
 

Yes. Thanks.

"T. Valko" wrote:

Use the key combination of CTRL,SHIFT,ENTER

Biff

"ron" wrote in message
...
I have forgotten how to re-establish the brackets { } at the beginning and
end of a conditional sum formula. They disappear when I modify the formula
and I have forgotten how to re-establish them. Can anyone help me?