### description:

Return the average (arithmetic mean) of its arguments specified by a given criteria. |

### syntax:

=AVERAGEIF( range, criteria, [average_range] ) |

### required arguments:

range |
The range of cells that you want to apply the criteria against. |

criteria |
The criteria used to determine for which numbers calculate the average. |

### optional arguments:

[average_range] |
The cells to average. When omitted, the range is used. |