Expression Language Reference
    Preparing search index...
    • Returns the average (arithmetic mean) of all the values in a range that meet a given criteria.

      Category: Statistical

      Parameters

      • range: any

        One or more values to average, including numbers or names, arrays, or references that contain numbers.

      • criteria: any

        The criteria in the form of a number, expression, value reference, or text that defines which values are averaged.

      • average_range: any

        Optional. The actual set of values to average. If omitted, range is used.

      • ...args: any[]

      Returns number | Error