FormulaCraft

COUNTIF

Count the cells in a range that meet a condition.

COUNTIF returns how many cells satisfy a single criterion — useful for tallying statuses, categories, or thresholds.

Excel
=COUNTIF(A:A, "Complete")
Google Sheets
=COUNTIF(A:A, "Complete")

How it works

  1. 1A:A is the range to scan.
  2. 2"Complete" is the value to count.

Need a version for your data?

Try: “Count how many cells in column A say Complete”

Related

SUMIFSUMIFSCOUNTIFS