Count records that meet multiple criteria
Use COUNTIFS to count open tasks at a selected location.
Copyable formulas
English Excel · en-US
=COUNTIFS(B2:B5,E2,C2:C5,E3)Turkish Excel · tr-TR
=ÇOKEĞERSAY(B2:B5;E2;C2:C5;E3)Sample data
Enter the headers and sample records in A1:C5.
| Task | Location | Status |
|---|---|---|
| Count | L01 | Open |
| Report | L01 | Closed |
| Delivery | L02 | Open |
| Review | L01 | Open |
- E2 = L01
- E3 = Open
Enter the formula in F2.
To try the Turkish formula, use the sample data on the Turkish page.
Expected result
2
How it works
Both conditions must be true on the same row. Change E2 to L02 for 1 or L99 for 0. Update the row bounds of both criteria ranges together.
Compatibility
Excel for Microsoft 365 and Excel 2016, 2019, 2021, and 2024.