COUNTIF function

Category:Statistics

Name in English:COUNTIF

That makes?

Counts the cells in a range that meet the specified condition.

Syntax

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.

Examples

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”

Leave a Comment