Reference
No results for 'undefined'
    Powered by Algolia

    COUNTIF

    Counts the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list

    Syntax

    =COUNTIF(criteria_range, criteria)

    Parameters

    1. criteria_range
      • Type: Range
      • Description: The range in which to evaluate the associated criteria
    2. criteria
      • Type: String
      • Description: The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. Criteria aren't case sensitive. In other words, the string "apples" and the string "APPLES" will match the same cells. Wildcard characters —the question mark (?) and asterisk (*)—can be used in criteria. A question mark matches any single character. An asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) in front of the character.

    Returns

    • Type: Any
    • Description: Number of times criteria is met

    Example

    =COUNTIF(A1:A12,"New York")

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents