Count Students Scoring A
I need to count how many students scored >= 90 on the 'Final Exam'.
=COUNTIFS(B2:B10, "Final Exam", C2:C10, ">=90") How it works: The COUNTIFS function counts cells that meet multiple criteria. In this formula, it first checks the range B2:B10 for cells that exactly match "Final Exam". Then, for those same rows, it checks the range C2:C10 for scores that are greater than or equal to 90. Only rows that satisfy BOTH conditions are included in the final count, providing an accurate tally of high-achieving students on that specific exam.
Data Setup
| Student Name | Exam Type | Score |
|---|---|---|
| Alice | Midterm | 85 |
| Bob | Final Exam | 92 |
| Charlie | Quiz | 78 |
| David | Final Exam | 95 |
| Eve | Midterm | 88 |
| Frank | Final Exam | 89 |
| Grace | Quiz | 91 |
| Heidi | Final Exam | 90 |
| Ivan | Midterm | 75 |
| Judy | Final Exam | 98 |
Step-by-Step Guide
Enter your student data into an Excel sheet. Ensure you have columns for 'Exam Type' (e.g., Column B) and 'Score' (e.g., Column C).
Select an empty cell where you want the result to appear (e.g., D1).
Type the COUNTIFS formula: `=COUNTIFS(B2:B10, "Final Exam", C2:C10, ">=90")`
Press Enter. The cell will display the total count of students who scored 90 or above on the Final Exam.