How To Do COUNTIF In Excel?

Select the cell where you want the result

Type `=COUNTIF(range, criteria)`

Replace `range` with the cells you want to evaluate

Replace `criteria` with the condition you want to count

Press Enter

Example: `=COUNTIF(A1:A10,”Apple”)`

Example: `=COUNTIF(B1:B20,”>50″)`

Example: `=COUNTIF(C1:C100,”<>0″)`

Use double quotes around text criteria

Use comparison operators like `>`, `<`, `=`, `>=`, `<=`, `<>`

Use cell references for criteria if needed, such as `=COUNTIF(A1:A10,D1)`

Suggested for You

Trending Today