Countif Excel Formula

What is the use of Countif formula?

Counts of items in a list matching a condition

Syntax of Countif formula:
countif(in this range, values meeting this criteria)

Examples of Excel Countif formula:
countif(A1:A20, 1) = counts how many cells have "1"
countif(A1:A20, "<3") = counts how many cells have less than 3

Buy Excel Formula E-book | Learn more about Excel Countif Formula

More Logical & Reference Functions : And | Countblank | Countif | If | Large | Max | Min | Not | Or | Small | Sumif | Vlookup

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions