I like the conditional sum wizard with one exception. I can't edit the
resulting formula without invalidating it. The wizard adds a { to the front
of the formula and a } at the end of the formula. When I attempt to edit the
formula the { and the } disappear and the formula no longer functions. Even
if I add the { and th } back it still doesn't work.

How can I edit a conditional sum wizard formula without invalidating its
functionality.

You have to hit ctrl-shift-enter to enter your array formulas. Excel will add
the {}'s if you do it correctly.

ron wrote:

I like the conditional sum wizard with one exception. I can't edit the
resulting formula without invalidating it. The wizard adds a { to the front
of the formula and a } at the end of the formula. When I attempt to edit the
formula the { and the } disappear and the formula no longer functions. Even
if I add the { and th } back it still doesn't work.

How can I edit a conditional sum wizard formula without invalidating its
functionality.

--

Dave Peterson

After you edit an array formula you have to press ctrl+shift+enter. If you
done correctly Exel will put { }. Don't manual put curly brackets yourself.


"ron" wrote:

I like the conditional sum wizard with one exception. I can't edit the
resulting formula without invalidating it. The wizard adds a { to the front
of the formula and a } at the end of the formula. When I attempt to edit the
formula the { and the } disappear and the formula no longer functions. Even
if I add the { and th } back it still doesn't work.

How can I edit a conditional sum wizard formula without invalidating its
functionality.

You guys are wonderful. Thanks.

"Teethless mama" wrote:

After you edit an array formula you have to press ctrl+shift+enter. If you
done correctly Exel will put { }. Don't manual put curly brackets yourself.


"ron" wrote:

I like the conditional sum wizard with one exception. I can't edit the
resulting formula without invalidating it. The wizard adds a { to the front
of the formula and a } at the end of the formula. When I attempt to edit the
formula the { and the } disappear and the formula no longer functions. Even
if I add the { and th } back it still doesn't work.

How can I edit a conditional sum wizard formula without invalidating its
functionality.

You guys are wonderful. Thanks.

"Teethless mama" wrote:

After you edit an array formula you have to press ctrl+shift+enter. If you
done correctly Exel will put { }. Don't manual put curly brackets yourself.


"ron" wrote:

I like the conditional sum wizard with one exception. I can't edit the
resulting formula without invalidating it. The wizard adds a { to the front
of the formula and a } at the end of the formula. When I attempt to edit the
formula the { and the } disappear and the formula no longer functions. Even
if I add the { and th } back it still doesn't work.

How can I edit a conditional sum wizard formula without invalidating its
functionality.