Hi,
I want to find the standard deviation on a certain set of data with conditional statements.
For example I want to find the standard deviation of Sales only if the Rank = A and Month = 1.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
This is what I came up with:
=STDEV(IF(AND(A2:A6=H2,C2=1),B2:B6))
It works if I only take the first 5, as soon as I take the rest my result changes but it should not because of the conditions.
Any help would be appreciated.
Thanks!
I want to find the standard deviation on a certain set of data with conditional statements.
For example I want to find the standard deviation of Sales only if the Rank = A and Month = 1.
Rank | SALES | MONTHS |
A | 1 | 1.00 |
A | 10 | 1.00 |
A | 2 | 1.00 |
A | 10 | 1.00 |
A | 1 | 1.00 |
B | 3 | 1.00 |
B | 3 | 2.00 |
B | 3 | 1.00 |
B | 3 | 2.00 |
B | 3 | 1.00 |
B | 3 | 2.00 |
B | 3 | 1.00 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
This is what I came up with:
=STDEV(IF(AND(A2:A6=H2,C2=1),B2:B6))
It works if I only take the first 5, as soon as I take the rest my result changes but it should not because of the conditions.
Any help would be appreciated.
Thanks!