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.

						I	II	III
					Rater 1	4	4	0
					Rater 2	0		0
IFERROR(AVERAGEIF(K4:K5,"<>0",K4:K5),"")	Mean	4	4
					Std Dev	?	?	?

<colgroup><col span="9"></colgroup><tbody>
</tbody>

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