Help with Formulas and array functions

[Novicesportsperformer]

Hi All,

I am wondering if you could help me?

I have a table (TBLSJ) which is looking at athlete Jumps a bit like this:

[TABLE="width: 357"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Jump[/TD]
[TD]Type[/TD]
[TD]Male/Female[/TD]
[/TR]
[TR]
[TD]Player 1 [/TD]
[TD]11/03/2018[/TD]
[TD]47[/TD]
[TD]SJ[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]Player 2[/TD]
[TD]01/04/2018[/TD]
[TD]54[/TD]
[TD]R[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]Player 1 [/TD]
[TD]03/04/2018[/TD]
[TD]57[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]Player 3[/TD]
[TD]05/05/2018 [/TD]
[TD]46[/TD]
[TD]SJ[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]Player 3[/TD]
[TD]10/05/2018[/TD]
[TD]40[/TD]
[TD]L[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]Player 2[/TD]
[TD]05/05/2018[/TD]
[TD]33[/TD]
[TD]SJ[/TD]
[TD]M[/TD]
[/TR]
</tbody>[/TABLE]

I am wondering do people know a formula that would allow me to analyse the average and Standard deviation of all the SJ type jumps for just the female athletes?

Thank you very much and appreciate any help on this!

 

[Eric W]

The formulas I provided in your other thread can easily be adapted to this situation:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Name	Date	Jump	Type	Male/Female		Type	Sex	Average	Std. Dev.
2	Player 1	11/3/2018	47	SJ	M		SJ	F	46	#DIV/0!
3	Player 2	1/4/2018	54	R	M
4	Player 1	3/4/2018	57	L	M
5	Player 3	5/5/2018	46	SJ	F
6	Player 3	10/5/2018	40	L	F
7	Player 2	5/5/2018	33	SJ	M
Sheet2

Cell Formulas
Range	Formula
I2	=AVERAGEIFS(C:C,D:D,G2,E:E,H2)
J2	{=STDEV.S(IF(D2:D7=G2,IF(E2:E7=H2,C2:C7)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

The standard deviation in this example is #DIV/0! since only 1 value in your sample table matches your criteria.

 

[Novicesportsperformer]

Hi Eric,

Thank you again for your reply.

I thought I could easily adapt it but I just wanted to be sure on this Forum.

Thank you again for you help!