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".
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.
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.