COUNTIF Function in Excel
Learn how to count cells that meet a specific condition. With AutoExel, you get automatic counting with AI.
Try AutoExel for FreeWhat is COUNTIF?
COUNTIF is an Excel function that counts how many cells in a range meet a specific condition.
Syntax: =COUNTIF(range, criteria)
- range: The cells to count
- criteria: The condition to check
Practical Examples
Count values greater than 100
=COUNTIF(A1:A10, ">100")
Counts how many cells in A1:A10 contain values greater than 100
Count cells containing specific text
=COUNTIF(B1:B100, "Completed")
Counts how many cells contain exactly "Completed"
Count non-empty cells
=COUNTIF(C1:C50, "<>")
Counts cells that are not empty
Common Mistakes
Incorrect criteria format
Always use quotes for text criteria and comparison operators: ">100" not >100
AutoExel Counts Automatically for You
Upload your file and ask "How many sales are above 1000?" - AutoExel does the rest with AI.
Try AutoExel Now