STDEVA excel formula to meet with two criteria

[blackorchids2002]

Hi Master,

How would I get the standard deviation on below table that will meet two criteria?
I want to get the standard deviation for weight of the SKU with the same month.

Month	SKU	Std Dev. Thickness	Std Dev. Weight	Ave. Thickness	Ave. Weight	Thickness	Weights
Aug-14	Orig.			5.6215	6.5317	5.1	7
Sep-14	Orig.			5.6215	6.5317	5	6.8
Aug-14	Orig.			5.6215	6.5317	6	5.2
Aug-14	Raw			5.6215	6.5317	5.1	6.6
Aug-14	Raw			5.6215	6.5317	5.3	6.2
Sep-14	Orig.			5.6215	6.5317	6	7.2
Aug-14	Orig.			5.6215	6.5317	5.3	5.5
Aug-14	Raw			5.6215	6.5317	5.2	6.8
Sep-14	Orig.			5.6215	6.5317	4.6	6.4
Aug-14	Orig.			5.6215	6.5317	4.7	6.4
Aug-14	Orig.			5.6215	6.5317	5	6.2

<tbody>
</tbody>

Thanks,
Blackorchids2002

 

[Andrew Poulsom]

Example:

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	Month	SKU	Std Dev. Thickness	Std Dev. Weight	Ave. Thickness	Ave. Weight	Thickness	Weights	Month	Aug-14
2	Aug-14	Orig.			5.6215	6.5317	5.1	7	SKU	Orig.
3	Sep-14	Orig.			5.6215	6.5317	5	6.8	STDEV	0.719722
4	Aug-14	Orig.			5.6215	6.5317	6	5.2
5	Aug-14	Raw			5.6215	6.5317	5.1	6.6
6	Aug-14	Raw			5.6215	6.5317	5.3	6.2
7	Sep-14	Orig.			5.6215	6.5317	6	7.2
8	Aug-14	Orig.			5.6215	6.5317	5.3	5.5
9	Aug-14	Raw			5.6215	6.5317	5.2	6.8
10	Sep-14	Orig.			5.6215	6.5317	4.6	6.4
11	Aug-14	Orig.			5.6215	6.5317	4.7	6.4
12	Aug-14	Orig.			5.6215	6.5317	5	6.2
Sheet1

Cell Formulas
Range	Formula
J3	{=STDEVA(IF((A2:A12=J1)*(B2:B12=J2),H2:H12))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[blackorchids2002]

Thanks Andrew for the help. It really works

Example:

Excel 2010

	A	B	C	D	E	F	G	H	I	J
1	Month	SKU	Std Dev. Thickness	Std Dev. Weight	Ave. Thickness	Ave. Weight	Thickness	Weights	Month	Aug-14
2	Aug-14	Orig.			5.6215	6.5317	5.1	7	SKU	Orig.
3	Sep-14	Orig.			5.6215	6.5317	5	6.8	STDEV	0.719722
4	Aug-14	Orig.			5.6215	6.5317	6	5.2
5	Aug-14	Raw			5.6215	6.5317	5.1	6.6
6	Aug-14	Raw			5.6215	6.5317	5.3	6.2
7	Sep-14	Orig.			5.6215	6.5317	6	7.2
8	Aug-14	Orig.			5.6215	6.5317	5.3	5.5
9	Aug-14	Raw			5.6215	6.5317	5.2	6.8
10	Sep-14	Orig.			5.6215	6.5317	4.6	6.4
11	Aug-14	Orig.			5.6215	6.5317	4.7	6.4
12	Aug-14	Orig.			5.6215	6.5317	5	6.2

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula J3 {=STDEVA(IF((A2:A12=J1)*(B2:B12=J2),H2:H12))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>