Free AVERAGEIF Formula Generator

Returns the average of all cells in a range that meet a given criteria.

Generated Formula
=AVERAGEIF(range, criteria)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Related Formulas

SUMIFCOUNTIFPMTSUMIFSCOUNTIFS

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More