STANDARD DEVIATION BASED ON MULTIPLE CRITERIA

[blimes]

	A	B	C	D	E	F	G	H	I
1	10	16	18
2	10	14	21
3	7	16	43
4	8	14	22
5	10	16	14

This is a small sample of a larger worksheet is cell f1 how would i do a standard deviation of column C based on the cells with a value in Column A=10 and Column B=16?

Thanks
Adam

 

[AhoyNC]

Try:
This is an array formula that must be entered with CTRL-SHIFT-ENTER.

Book1
	A	B	C	D	E	F
1	10	16	18			2.828
2	10	14	21
3	7	16	43
4	8	14	22
5	10	16	14
Sheet1

Cell Formulas
Range	Formula
F1	F1	=STDEV.S(IF(A1:A5=10,IF(B1:B5=16,C1:C5)))
Press CTRL+SHIFT+ENTER to enter array formulas.