How can I replicate a conditional sum formula?

Hi!

Double click the cell with the formula.

Hold down the CTRL and SHIFT keys then hit ENTER.

Biff

"Dan" <[email protected]> wrote in message
news:[email protected]...
> When I copy a conditional sum formula created using the addin wizard there
> is
> a { symbol in front of the SUM statement. If I edit the cell, the {
> disappears and the formula no longer works. Consequently I have to use the
> wizard cell by cell rather than copying it.
>
>

When I copy a conditional sum formula created using the addin wizard there is
a { symbol in front of the SUM statement. If I edit the cell, the {
disappears and the formula no longer works. Consequently I have to use the
wizard cell by cell rather than copying it.

Hi!

Double click the cell with the formula.

Hold down the CTRL and SHIFT keys then hit ENTER.

Biff

"Dan" <[email protected]> wrote in message
news:[email protected]...
> When I copy a conditional sum formula created using the addin wizard there
> is
> a { symbol in front of the SUM statement. If I edit the cell, the {
> disappears and the formula no longer works. Consequently I have to use the
> wizard cell by cell rather than copying it.
>
>