Understanding AVERAGEIF Formula
AVERAGEIF is a function for calculating the average of cells that meet a certain criteria. The AVERAGEIF function calculates the total average of cells in a range that satisfy a single given condition. We give a certain condition to find the average of the cells in a range. Let us look at syntax and example to have better understanding.
AVERAGEIF function Average numbers in a range that meet given criteria.
Syntax of AVERAGEIF formula
The syntax of the AVERAGEIF function is as follows:
=AVERAGEIF (range, criteria, [average_range])
The first argument(range) specifies the range to which criteria should be applied.
The second argument(criteria) specifies the criteria.
The third argument(average_range) specifies the range of values to average.
Let us look at example for better understanding
Example for AVERAGEIF Function
Only one condition is supported by AVERAGEIF. Use the AVERAGEIFS function if you need to apply multiple criteria. To Know how to use AVERAGEIFS function click here.
Practice AVERAGEIF 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 AVERAGEIF function. See how AVERAGE and AVERAGEIFS function works and practice it.
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.
