﻿ AVERAGEIF | Spread.NET 16 Formula Reference
Formula Functions / Functions A to C / AVERAGEIF
In This Topic
AVERAGEIF
In This Topic

This function calculates the average of the specified numeric values provided that they meet the specified criteria.

#### Syntax

AVERAGEIF(value1,value2,...,condition)

AVERAGEIF(array,condition)

AVERAGEIF(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.

#### 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

AVERAGEIF(A1,B3,D5,E9,L8,L9,"<5000")

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

#### Version Available

This function is available in product version 5.0 or later.