count values between dates

[crashbrn34]

I have the below spreadsheet for test scores. The first column lists the test dates for each student and another lists the test scores. if the student passed, there's a "P" for their score. The spreadsheet has 260 records with dates throughout the year. I'd like to count how many records with a date between 3/1/19 and 5/15/19 have a "P" listed. (Is it necessary to convert the "P" to a number (e.g., 100) so all values are numerical?)

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Test Date[/TD]
[TD]Student[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]7/28/19[/TD]
[TD]Sara J[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]6/20/19[/TD]
[TD]Sara J[/TD]
[TD]233[/TD]
[/TR]
[TR]
[TD]3/15/19[/TD]
[TD]Alphie D[/TD]
[TD]230[/TD]
[/TR]
[TR]
[TD]6/28/19[/TD]
[TD]Barney C[/TD]
[TD]P[/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

Hi DanteAmor, Thanks a lot for pointing it. I was stuck with that part.

I like to help even a little.

 

[Sam_D_Ben]

I like to help even a little.

I know that Dan.