crashbrn34
New Member
- Joined
- Aug 29, 2019
- Messages
- 7
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?)
<tbody>
</tbody>
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>