Reference
No results for 'undefined'
    Powered by Algolia

    COUNTIFS

    Applies criteria to cells across multiple ranges and counts the number of times all criteria are met

    Syntax

    =COUNTIFS(criterias, criterias, ...)

    Parameters

    1. criterias [repeatable]
      • Type: Any
      • Description: Ranges and criterias to apply. All ranges must be of the same size. 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 all criteria are met

    Example

    =COUNTIFS(B1:B12,">10", C1:C12,"Tom")

    Try It Now

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