AVERAGEIFS FUNCTION

Understanding AVERAGEIFS Function

AVERAGEIFS is a function for calculating the average of cells that meet multiple criteria. When corresponding cells meet criteria, AVERAGEIFS can be used to average values. AVERAGEIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Syntax of AVERAGEIFS function

The syntax of the AVERAGEIFS function is as follows:

=AVERAGEIFS (average_range, range1, criteria1, [range2], [criteria2], …)

Note: AVERAGEIF is used to match single criteria while AVERAGEIFS is used to match multiple criteria.

Lets us have a better understanding by looking at the example below:

Example For AVERAGEIFS Function

Practice AVERAGEIFS function below:

The formula can be entered in the highlighted cell. If the formula entered is correct, it shows good job. If the formula is entered incorrectly, the result will be invalid. Please keep in mind that you can only enter formula in the highlighted cells.

Hurray! You know now how to use AVERAGEIFS function. Practice AVERAGEAVERAGEIF and other functions by checking our articles below.

Are you looking for a full fledged training? You are at the right place.

At TechnoExcel :

You can upskill yourself with:

Why us?

Techno Excel is a leading provider of Excel courses and data analytics courses. We not only teach you how to use excel but also help customize it for your exact needs! Make the most out of your career with Techno Excel. Students can join via classroom course or via Online course. This is the place where students can easily learn the required skill set to get placed immediately

Learn data science and other technologies at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace. Whether you are a beginner or a professional looking for advanced techniques, we have the right course for you. Hurry up!! Book your seat now!!!

Class-room of your choice

Upskill yourself by attending classroom or online class.

Flexible timings

Learn at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace.

Class-Room Size

With limited students in class, attention to each student’s performance will be given.

Industry Ready Curriculum

The course is designed for people who want to work in the industry.

Book your free consultation now

If you want to improve your skills and get ready for the workforce! Please enter your information below, and one of our expertise will contact you shortly.

    Leave a Comment

    Your email address will not be published. Required fields are marked *