This article will demonstrate how to use the Excel Average Function to compute the average of values in a specified range of cells. It explains the fundamental syntax, how to use the function with various kinds of data, and how to troubleshoot typical issues.
The average is calculated by adding up all the values in your data and dividing by the number of values in the data. In this blog post, you will learn all three different Average functions.
AVERAGE(), AVERAGEIF() and AVERAGEIFS()
Excel AVERAGE function
AVERAGE(num1,num2, ...) – num1, num2, etc. are the numbers or cell references
The average includes cells with zero values and ignored the empty cells and text.
Go to cell E18, type the formula =AVERAGE(E2:E16) and press Enter.
Excel AVERAGEIF function
AVERAGEIF(range, criteria, [average_range])
range – Range of cells that you want to evaluate
criteria – Condition that must be met for a cell to be included in the average calculation
average_range – Range of cells that you want to average
Suppose you need to compute the average sales by specific country. In the below example, the formula returns the average sales for the country Germany.
Go to cell E20, type the formula =AVERAGEIF($C$2:$C$16,"Germany",E2:E16), and press Enter.
Excel AVERAGEIFS function
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
average_range – Range of cells to be averaged
criteria_range and criteria – Arguments are used to check, which cells are included in the average. You can use multiple criteria_range and criteria statements.
In the below example, the formula returns the average sales for both field country and region.
Go to cell D20, type the formula =AVERAGEIFS(D2:D16,$C$2:$C$16,"France",B2:B16,"Ceuta" ) and press Enter.
Conclusion
The Excel Average Function is an aggregate function that will help to analyse your data. It may calculate the average of a range of cells, the average of a single column or row, or the average of many columns or rows.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
