Spread WPF Documentation
Spread WPF Documentation / Formula Reference / Formula Functions / COUNTA
In This Topic
    COUNTA
    In This Topic

    Summary

    This function returns the number of number of cells that contain numbers, text, or logical values.

    Syntax

    COUNTA(value1,value2,...)

    COUNTA(array)

    Arguments

    The arguments may be separate values or an array of values. Up to 255 arguments of individual cells may be included.

    Remarks

    This function counts the number of non-empty cells in the specified cell range.

    This function differs from COUNT because it includes text or logical values as well as numbers.

    Data Types

    Accepts cell references. Returns numeric data.

    Examples

    COUNTA(B2,D2,E4,E5,E6)

    COUNTA(A1:G5)

    COUNTA(R6C3:R9C4)

    See Also