CONDITIONAL SUM WIZARD

[navyaa]

I Used the conditional sum wizard but then the range that i had used change so i went and changed it in the formula from the conditonal wizard(the formula in the cell).

The problem is that it does not update the contents of the cell to include the new values after i changed the range. I think this is because you are supposed to enter array formulas a different way..

WHAT SHOULD I DO...ANY SUGGESTIONS??
navya.

 

[Aladin Akyurek]

You need to hit control+shift+enter at the same time to enter an array formula, not just enter. Also after an edit.

 

[PaddyD]

Hi - not sure about the conditional sum wizard, so people who use that more might have something specific to say, but how about posting back with details of what data you've got, where it is on the sheets, what you're trying to do & the formula you've got at the momnet...

Paddy

 

[navyaa]

THANK YOU VERY MUCH THE CTRL+SHIFT+ENTER WORKED...

Will post details if i get stuck again...

Thank you again!!