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?)

Test Date	Student	Score
7/28/19	Sara J	P
6/20/19	Sara J	233
3/15/19	Alphie D	230
6/28/19	Barney C	P

<tbody>
</tbody>

 

[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.