COUNTIF

Definition: COUNTIF is a function that counts the number of cells in a range that meet a specified condition.

Syntax: =COUNTIF(range, criteria)

Situation: This formula is suitable when you need to count the number of cells in a range that meet a specified condition, such as counting the number of cells with a value greater than 5.

Example: If you have a range A1:A10 with some cells containing numbers, the number of cells greater than 5 can be found using the formula =COUNTIF(A1:A10, “>5”), which returns the count of cells containing numbers greater than 5.