Help With Standard deviation formula

[Novicesportsperformer]

Hi Everyone I really need your help.

I have a Table called TBLSJ :

Date	Name	Jump height	Type of jump
01/02/2018	Player 1	54	SJ
01/02/2018	Player 1	60	Left
01/02/2018	Player 1	53	Right
05/07/2018	Player 1	46	Left
05/07/2018	Player 1	65	Right
05/07/2018	Player 1	48	SJ
03/09/2018	Player 1	59	right
03/09/2018	Player 1	39	SJ
03/09/2018	Player 1	48	Left
04/10/2018	Player 1	45	Left
04/10/2018	Player 1	50	SJ
04/10/2018	Player 1	53	Right

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I was wondering how could i get the standard deviation of Jump results that are labeled 'SJ'?

Really appreciate any help on this, thank you

 

[Eric W]

Try:

	A	B	C	D	E	F	G	H	I	J
1	Date	Name	Jump height	Type of jump		Type	Player	Avg	Std. Dev.
2	1/2/2018	Player 1	54	SJ		SJ	Player 1	47.75	6.344289
3	1/2/2018	Player 1	60	Left
4	1/2/2018	Player 1	53	Right
5	5/7/2018	Player 1	46	Left
6	5/7/2018	Player 1	65	Right
7	5/7/2018	Player 1	48	SJ
8	3/9/2018	Player 1	59	right
9	3/9/2018	Player 1	39	SJ
10	3/9/2018	Player 1	48	Left
11	4/10/2018	Player 1	45	Left
12	4/10/2018	Player 1	50	SJ
13	4/10/2018	Player 1	53	Right

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

Sheet7​

Worksheet Formulas Cell Formula H2 =AVERAGEIFS(C:C,B:B,G2,D:D,F2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Array Formulas Cell Formula I2 {=STDEV.S(IF(B2:B13=G2,IF(D2:D13=F2,C2:C13)))} <thead> </thead><tbody> </tbody> Ent ered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[Novicesportsperformer]

Thank you so much - really appreciate this!

 

[Eric W]

You're welcome!