Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Wizard
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Wizard
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Wizard
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Wizard
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Wizard
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Sum Wizard - Where is it in 2007 | Excel Discussion (Misc queries) | |||
Conditional sum wizard problem--Excel 2000 | Excel Discussion (Misc queries) | |||
Conditional Sum Wizard Error | Excel Discussion (Misc queries) | |||
using wizard and conditional sum | Excel Worksheet Functions | |||
how many condition for conditional sum wizard ? | Excel Worksheet Functions |