Calculate Stdev with Array-formula

[SIGE]

Hi there,

I would like to calculate the Stdev from a range (B1:B10) when a condition on another range (A1:A10) is met.

I am trying to wing it with below formula but the output is not what it should be ...
{=STDEV((A1:A10<=25)*B1:B10)}


Anybody an idea?
Thanks in advance,
Sige

 

[shg]

Try

=STDEV(IF(A1:A10<=25, B1:B10))

... confirmed with CSE.

 

[VoG]

Try

=STDEV(IF(A1:A10<=25,B1:B10))

 

[SIGE]

Roxx the donkey!
Thanks a lot^^

 

[SIGE]

I am trying a double condition :
{=STDEV(IF(AND(Qty>$E$2;Qty<$E$4);ANS))}

But it turns a Div/0! error, while it shoudn't.

Any suggestion to calculate the Stdev with a double condition?

Thanks in advance, Sige

 

[shg]

Have you watched the formula evaluate to see what's happening?

Is E4>E2?

 

[SIGE]

Hi Shg,

Yes the evaluation of the AND turns a single FALSE , no range.

But I've found what it needs to do:

{ =STDEV(IF(Qty>$E$2;IF(Qty<$E$4;ANS))) }

Woot, Sige

 

[shg]

Right, because AND and OR always evaluate ALL of their arguments in one fell swoop.