Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
COUNTIF
COUNTIF returns how many cells satisfy a single criterion — useful for tallying statuses, categories, or thresholds.
Topic:COUNTIF & COUNTIFSExcel
=COUNTIF(A:A, "Complete")Google Sheets
=COUNTIF(A:A, "Complete")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A:A is the range to scan.
- 2"Complete" is the value to count.
More on COUNTIF & COUNTIFS
See all →Reference
COUNTIFS
Count cells that meet several conditions simultaneously.
How-toCOUNTIF vs COUNTIFS: how they differ in Excel and Sheets
Learn the difference between COUNTIF (single condition) and COUNTIFS (multiple conditions) for counting in Excel and Google Sheets.
Error fixFix COUNTIF
COUNTIF not working in Excel and Google Sheets — fix criteria syntax, data-type mismatches, wildcard errors, and case-sensitivity misunderstandings.
How-toHow to count cells not equal to a value
Use COUNTIF with the <> operator to count all cells that do not match a specific value.
Error fixFix Wrong count
COUNTIF returns the wrong count in Excel and Google Sheets — fix wildcard over-matching, duplicate rows, hidden rows, blank cell handling, and date format issues.
How-toHow to use COUNTIF with a wildcard
Count cells that contain, start with, or end with specific text using COUNTIF with * and ? wildcard characters.