Spread.NET 18 Formula Reference
Formula Functions / Functions A to C / COUNTIFS
In This Topic
    COUNTIFS
    In This Topic

    This function returns the number of cells that meet multiple conditions.

    Syntax

    COUNTIFS(cellrange,condition)

    Arguments

    This function has these arguments:

    Argument Description
    cellrange Range of cells to count; cell range reference
    condition Condition that determines which cells are counted, as a text, number, or expression (where expressions use the relational operators detailed in Operators in a Formula)

    Data Types

    Accepts cell range reference. Returns numeric data.

    Examples

    COUNTIFS(A1:G5,"test",B3:D3,"=Yes")

    COUNTIFS(R6C3:R9C4,"<2")

    Version Available

    This function is available in product version 5.0 or later.

    See Also

    COUNT | COUNTA | COUNTBLANK | SUMIF | Statistical Functions