Formula Library

COUNTIFS

math

Counts cells that meet multiple conditions across multiple ranges.

Syntax

=COUNTIFS(range1, criteria1, [range2, criteria2, ...])

Example

Excel
=COUNTIFS(A:A, "Open", B:B, ">100")

Counts rows where column A is "Open" and column B is greater than 100.

Tips & Notes

  • →All criteria are ANDed
  • →All ranges must be same size
  • →Great for dashboard KPI counts

See Also

COUNTIFSUMIFS

Need a custom COUNTIFS formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.