Cellgrids Cellgrids
Home › Excel formulas › Statistical › AVERAGE + IFERROR

AVERAGE + IFERROR Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

AVERAGE + IFERROR is an Excel Statistical function. Wraps AVERAGE in IFERROR to avoid a #DIV/0! error when the range is empty.

AVERAGE + IFERROR syntax

=IFERROR(AVERAGE(range), "No Data")

Arguments

When to use AVERAGE + IFERROR

Showing 'No Data' instead of an error when a team hasn't logged any scores yet.

Practice AVERAGE + IFERROR online, free

Open the live Excel-style spreadsheet and try AVERAGE + IFERROR yourself. No Excel install or sign-up needed to start.

Practice AVERAGE + IFERROR now →

More Statistical functions

Frequently asked questions

What does the AVERAGE + IFERROR function do in Excel?

Wraps AVERAGE in IFERROR to avoid a #DIV/0! error when the range is empty.

What is the syntax of AVERAGE + IFERROR in Excel?

The syntax is =IFERROR(AVERAGE(range), "No Data"). range: Range of numbers to average.

Where can I practice AVERAGE + IFERROR online for free?

Open the free live spreadsheet on Cellgrids and try AVERAGE + IFERROR yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts