Count Students Who Passed the Exam
I need to quickly count how many students scored above 60 in the final math exam.
=COUNTIF(B2:B11, ">60") How it works: The COUNTIF function counts cells within a specified range that meet a given criterion. In this scenario, `B2:B11` is the range containing the students' math scores. The criterion `">60"` tells Excel to count only those scores that are strictly greater than 60, effectively identifying how many students passed the exam based on your passing threshold.
Data Setup
| Student Name | Math Score |
|---|---|
| Alice | 75 |
| Bob | 55 |
| Charlie | 80 |
| David | 60 |
| Eve | 92 |
| Frank | 45 |
| Grace | 68 |
| Heidi | 70 |
| Ivan | 50 |
| Judy | 88 |
Step-by-Step Guide
Enter your student names in Column A (e.g., A2:A11) and their respective math exam scores in Column B (e.g., B2:B11).
Select an empty cell where you want the count to appear (e.g., C2).
Type the formula `=COUNTIF(B2:B11, ">60")` into the selected cell.
Press Enter. The cell will display the total number of students who scored above 60.
Explore More
Retrieve Student Guardian Contact Info
I have a student ID in one sheet and need to pull their guardian's email address from the school registry.
Combine First and Last Names for Roster
I have student first names in column A and last names in column B and need to merge them into 'Last, First' format.
Assign Letter Grades Based on Score
I want to automatically assign 'A', 'B', 'C', or 'F' based on the numeric score in the adjacent cell.
Sum Points for Specific Assignment Type
As a teacher, I want to calculate the total points earned across all students specifically on 'Homework' assignments, ignoring other assignment types like quizzes or exams. This helps me track overall progress for a particular category of work.