View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj
 
Posts: n/a
Default why cond sum wizard returns diff result as when formula typed out

can you give an example of the formula you want to use?

"ExcelKat" wrote:

When I use the conditional sum wizzard, I get the result that I want, however
I have MANY formulas to enter. So, knowing the structure and proper formula,
I wanted to just type the formula. However, when I do, I get a different
result because the conditional sum bracket doesn't stay or excel thinks the
formula is text.

I can't remember the short cut key to enforce a conditional sum formula and
I don't know a way around this. Can anyone help...too many formulas to do.
Thanks