Conditional Sum Brackets { }

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ron - 13 Jun 2007 18:22 GMT

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?

Reply to this Message

T. Valko - 13 Jun 2007 18:28 GMT

Use the key combination of CTRL,SHIFT,ENTER

Biff

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

Reply to this Message

ron - 13 Jun 2007 18:37 GMT

Yes. Thanks.

> Use the key combination of CTRL,SHIFT,ENTER
>
[quoted text clipped - 3 lines]
> > 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?

Reply to this Message

ron - 13 Jun 2007 18:30 GMT

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

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

Reply to this Message

Mike H - 13 Jun 2007 18:32 GMT

Ron,

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

Mike

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

Reply to this Message

ron - 13 Jun 2007 18:37 GMT

Yes. Thanks.

> Ron,
>
[quoted text clipped - 5 lines]
> > 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?

Reply to this Message