Spread Silverlight Documentation
Spread Silverlight Documentation / Formula Reference / Formula Functions / AVERAGEIFS
In This Topic
    AVERAGEIFS
    In This Topic

    Summary

    This function calculates the average of all cells that meet multiple specified criteria.

    Syntax

    AVERAGEIFS(value1,condition1,value2,...,condition2...)

    AVERAGEIFS(array,condition)

    AVERAGEIFS(array1,array2,...,condition)

    Arguments

    Each argument can be a double-precision floating-point value, an integer value, or an array (cell range). Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well. You can have up to 127 arguments for the conditions.

    Remarks

    This is a measure of the variability in a data set.

    Data Types

    Accepts numeric data. The condition accepts text, numeric, or expression data. Returns numeric data.

    Examples

    AVERAGEIFS(B2:B5,B2:B5,">90",B2:B5,"<100")

    AVERAGEIFS(R1C1,R3C2,"<>0")

    See Also