STDEV with multiple ifs

[Szaboteur]

Hello guys,

Can someone help me with this, please?


The average function works well but... can STDEV accomplish all the ifs in one single formule like the mean does?
I mean the scenarios I, II, III.
[TABLE="width: 576"]
<colgroup><col span="9"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I[/TD]
[TD]II[/TD]
[TD]III[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rater 1[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rater 2[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="colspan: 5"]IFERROR(AVERAGEIF(K4:K5,"<>0",K4:K5),"")[/TD]
[TD]Mean[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Std Dev[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]

This is how i would like to work like:

Give me a standard deviation value even if there is one rater (case II - which is always 0; more exactly the value divided by 0 should the function understand because there's no standard deviation), two raters (case I - which should output 0 standard deviation because in this case 0 has no numerical sens, there remains only one rater who is taken as a rater; 0 value means in fact that the responded gave a "rank" of cannot judge) and case III where there should output no value at all.

Is that possible or should i manully count that difference everytime?

Thanks, even for the thought provoking suggestions.

 

[James006]

Hi,

With an array function confirmed with simultaneously Control Shift Enter keys ...

=STDEV(IF(your test))

HTH