# STDEVA excel formula to meet with two criteria

#### blackorchids2002

##### Board Regular
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

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### Andrew Poulsom

##### MrExcel MVP
Example:

Excel 2010
ABCDEFGHIJ
1MonthSKUStd Dev. ThicknessStd Dev. WeightAve. ThicknessAve. WeightThicknessWeightsMonthAug-14
2Aug-14Orig.5.62156.53175.17SKUOrig.
3Sep-14Orig.5.62156.531756.8STDEV0.719722
4Aug-14Orig.5.62156.531765.2
5Aug-14Raw5.62156.53175.16.6
6Aug-14Raw5.62156.53175.36.2
7Sep-14Orig.5.62156.531767.2
8Aug-14Orig.5.62156.53175.35.5
9Aug-14Raw5.62156.53175.26.8
10Sep-14Orig.5.62156.53174.66.4
11Aug-14Orig.5.62156.53174.76.4
12Aug-14Orig.5.62156.531756.2
Sheet1
Cell Formulas
RangeFormula
J3{=STDEVA(IF((A2:A12=J1)*(B2:B12=J2),H2:H12))}
Press CTRL+SHIFT+ENTER to enter array formulas.

#### blackorchids2002

##### Board Regular
Thanks Andrew for the help. It really works

Example:

Excel 2010
ABCDEFGHIJ
1MonthSKUStd Dev. ThicknessStd Dev. WeightAve. ThicknessAve. WeightThicknessWeightsMonthAug-14
2Aug-14Orig.5.62156.53175.17SKUOrig.
3Sep-14Orig.5.62156.531756.8STDEV0.719722
4Aug-14Orig.5.62156.531765.2
5Aug-14Raw5.62156.53175.16.6
6Aug-14Raw5.62156.53175.36.2
7Sep-14Orig.5.62156.531767.2
8Aug-14Orig.5.62156.53175.35.5
9Aug-14Raw5.62156.53175.26.8
10Sep-14Orig.5.62156.53174.66.4
11Aug-14Orig.5.62156.53174.76.4
12Aug-14Orig.5.62156.531756.2

</tbody>
Sheet1

Array Formulas
CellFormula
J3{=STDEVA(IF((A2:A12=J1)*(B2:B12=J2),H2:H12))}

</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>

Replies
1
Views
152
Replies
4
Views
361
Replies
3
Views
608
Replies
1
Views
2K
Replies
2
Views
566

1,191,517
Messages
5,987,057
Members
440,074
Latest member
Emmanuelian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back