Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

AVERAGEIFS returns the average of all cells that meet multiple criteria. IFERROR returns the value specified if AVERAGEIFS evaluates to an error.

Other videos in this course

This video is part of a training course called Advanced IF functions.

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!