Average (with a condition)
Last updated 9 November 2026
Function reference › Other Functions
1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].
GIA_Other_Average
Return the average of the values in the range of cells, meeting a chosen criteria (absolute/negative/positive).
GIA_Other_Average(Range, Condition)| Argument | Use | Description |
|---|---|---|
Range | Required | The range of cells. |
Condition | Required | The criteria that defines which values will be chosen (absolute/negative/positive). |