FormulaCraft

COUNTIFS

Count cells that meet several conditions simultaneously.

COUNTIFS counts rows matching multiple criteria across different columns at once.

Excel
=COUNTIFS(A:A, "Open", B:B, ">500")
Google Sheets
=COUNTIFS(A:A, "Open", B:B, ">500")

How it works

  1. 1A:A = "Open" is the first condition.
  2. 2B:B > 500 is the second condition.
  3. 3Only rows matching both are counted.

Need a version for your data?

Try: “Count rows where status in A is Open and amount in B is over 500”

Related

SUMIFSUMIFSCOUNTIF