using a 'COUNT' function

[Novicesportsperformer]

Hi everyone I need some help.

I have a table (called TBLSJ) of data which looks like this:

[TABLE="width: 307"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Jump height[/TD]
[TD]Type of jump[/TD]
[/TR]
[TR]
[TD]01/02/2018[/TD]
[TD]Player 1[/TD]
[TD]49[/TD]
[TD]SJ[/TD]
[/TR]
[TR]
[TD]01/02/2018[/TD]
[TD]Player 1[/TD]
[TD]48[/TD]
[TD]Left[/TD]
[/TR]
[TR]
[TD]01/02/2018[/TD]
[TD]Player 1[/TD]
[TD]65[/TD]
[TD]Right [/TD]
[/TR]
[TR]
[TD]05/07/2018[/TD]
[TD]Player 1[/TD]
[TD]59[/TD]
[TD]Left[/TD]
[/TR]
[TR]
[TD]05/07/2018[/TD]
[TD]Player 1[/TD]
[TD]59[/TD]
[TD]Right [/TD]
[/TR]
[TR]
[TD]05/07/2018[/TD]
[TD]Player 1[/TD]
[TD]60[/TD]
[TD]SJ[/TD]
[/TR]
[TR]
[TD]03/09/2018[/TD]
[TD]Player 1[/TD]
[TD]66[/TD]
[TD]right [/TD]
[/TR]
[TR]
[TD]03/09/2018[/TD]
[TD]Player 1[/TD]
[TD]51[/TD]
[TD]SJ[/TD]
[/TR]
[TR]
[TD]03/09/2018[/TD]
[TD]Player 1[/TD]
[TD]48[/TD]
[TD]Left[/TD]
[/TR]
[TR]
[TD]04/10/2018[/TD]
[TD]Player 1[/TD]
[TD]57[/TD]
[TD]Left[/TD]
[/TR]
[TR]
[TD]04/10/2018[/TD]
[TD]Player 1[/TD]
[TD]49[/TD]
[TD]SJ[/TD]
[/TR]
[TR]
[TD]04/10/2018[/TD]
[TD]Player 1[/TD]
[TD]51[/TD]
[TD]Right [/TD]
[/TR]
</tbody>[/TABLE]

I was wondering if there is an easy 'count' function to find the number of 'SJ' Jumps player 1 completed

thank you very much I would appreciate your help on this

 

[steve the fish]

Sure. Place your table in A1:D13. Type Player 1 in F2. Type SJ in G2. In H2:

=COUNTIFS($B$2:$B$13,F2,$D$2:$D$13,G2)

 

[Novicesportsperformer]

Thank you so much! Do you know if there is a way to work out the standard deviation using a similar method?

 

[steve the fish]

Something like:

=STDEV(IF($B$2:$B$13=F2,IF($D$2:$D$13=G2,$C$2:$C$13)))

You MUST enter this with CTRL-SHIFT-ENTER if you want the correct result!