ExcelFlux

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.

Microsoft Excel reference