COUNTIF in Excel

What: A function in Excel used to count cells with conditions.

How:
Syntax of the COUNTIF function is very simple:
COUNTIF(range, criteria)
range — defines one or several cells to count. You put the range in a formula like you usually do in Excel, e.g. C2:C15.

criteria — defines the condition that tells the function which cells to count. It can be a number, text string, cell reference or expression. For instance, you can use the criteria like these: “10”, A2, “>=10”, “some text”.
refer ablebits