I am using a 2-condition Conditional StDev formula as follows:
{=STDEV(IF((Range1=Value1)*(Range2=Value2),Range3,))} [ctrl + shift + enter]
I am finding that, while the formula will produce a result, upon testing, the result is consistently incorrect. I'm hoping that I am somehow using the method incorrectly, and look to this forum for feedback. The following describes two different methods of calculating the Standard Deviation of the values in column z, for which x = Black and y = Yellow. The table of x, y and z values is below.
Calc Type StDev Result Formula
StDev(z1,z2,…zn) 16.58 =STDEV(Value1, Value2)
Conditional StDev 20.71 {=STDEV(IF((Range1=Value1)*(Range2=Value2),Range3,))}
x y z
Black Yellow 37
Black Green 13
Black Yellow 53
Black Green 68
Blue Yellow 69
Blue Green 81
Blue Yellow 89
Blue Green 50
Black Yellow 60
Black Green 24
Black Yellow 23
Black Green 93
Blue Yellow 52
Blue Green 46
Blue Yellow 94
Blue Green 23
Bookmarks