Name in English:COUNTIF
Counts the cells in a range that meet the specified condition.
COUNTIF (range, condition)
- range (required ): The range of cells to which the condition will apply to consider your account.
- condition (required ): The condition that must be met to be included in the account.
COUNTIF (A1: A5, “> 5”) = Counts the cells that have a value greater than 5
COUNTIF (B1: B5, “excel”) = Counts the cells that have the value “excel”