Count IEP Goals Met
I need to count how many students have 'IEP' status and have scored >80 on the final assessment.
=COUNTIFS(B2:B9,"IEP",C2:C9,">80") How it works: The COUNTIFS function allows you to count cells that meet multiple criteria. In this scenario, it first checks the 'IEP Status' column (B2:B9) for cells containing 'IEP'. Simultaneously, it checks the 'Final Assessment Score' column (C2:C9) for scores greater than 80. Only rows where *both* conditions are true are included in the final count, providing an accurate tally of IEP students who achieved the target score.
Data Setup
| Student Name | IEP Status | Final Assessment Score |
|---|---|---|
| Alice | IEP | 85 |
| Bob | Non-IEP | 90 |
| Charlie | IEP | 75 |
| David | IEP | 92 |
| Eve | Non-IEP | 70 |
| Frank | IEP | 81 |
| Grace | Non-IEP | 88 |
| Hannah | IEP | 65 |
Step-by-Step Guide
Organize your student data with columns for 'Student Name', 'IEP Status', and 'Final Assessment Score'.
Identify the range containing the 'IEP Status' (e.g., B2:B9).
Identify the range containing the 'Final Assessment Score' (e.g., C2:C9).
Enter the COUNTIFS formula into an empty cell: =COUNTIFS(B2:B9,"IEP",C2:C9,">80").
Press Enter to see the count of students who meet both criteria.