Count how many cells match a value or condition using COUNTIF.
Copy this formula
=COUNTIF(A:A, "Done")COUNTIF counts cells in a range that meet one criterion. Use a plain value for an exact match, or operators like ">100", "<>"&"" (non-blank), or "*text*" with wildcards for partial text.
=COUNTIF(B:B, ">=80")→12Counts scores of 80 or higher.
=COUNTIF(A:A, "*urgent*")→5Counts cells containing the word "urgent".
=COUNTIF(A2:A100, "<>Done")→14Counts cells that are not equal to Done, including blanks.
=COUNTIF(B2:B100, ">"&D1)→9Compares against the value in D1 instead of a typed number.
Multiple conditions
=COUNTIFS(A:A, "East", B:B, ">100")Use COUNTIFS to count on two or more conditions.
Use =COUNTA(A:A) for any non-empty cell, or =COUNTIF(A:A, "<>") to exclude truly blank cells.
Use COUNTIFS on the same range twice: =COUNTIFS(B:B, ">=50", B:B, "<=100").
Add two counts: =COUNTIF(A:A, "Done")+COUNTIF(A:A, "Closed").
Build the criterion with DATE: =COUNTIF(C:C, ">="&DATE(2026,1,1)) counts dates on or after 1 January 2026.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.