No results for 'undefined'
    Powered by Algolia


    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


    =COUNTIF(criteria_range, criteria)


    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.


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


    =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+.