How to Calculate Average, Minimum And Maximum in Excel (4 Easy Ways)

Calculating Average, Minimum and Maximum is a common and simple task in Excel. There are several methods to do it. In this article, you will learn how to calculate average minimum and maximum in excel with four easy methods.


Download Practice Book

You can download the free Excel template from here and practice on your own.


4 Easy Methods to Calculate Average, Minimum And Maximum in Excel

Method 1: Use Functions to Calculate Average, Minimum And Maximum in Excel

Let’s get introduced to our dataset first. I have made a dataset that represents some foods’ prices. In this method, I’ll use the AVERAGE, MIN, MAX functions to calculate average, minimum and maximum in Excel. The AVERAGE function calculates the average (arithmetic mean) of a group of numbers. The MIN function returns the smallest value from the numbers provided. And the MAX function returns the highest value in a set of data.

Functions to Calculate Average, Minimum And Maximum in Excel

Step 1:

➦ In Cell C13 type the formula given below-

=AVERAGE(C3:C9)

➦ Then hit the Enter button and the average will be evaluated.

Functions to Calculate Average, Minimum And Maximum in Excel

Step 2:

➦ Activate Cell C14 and write the formula-

=MIN(C3:C9)

➦ Press the Enter button now to get the minimum value.

Functions to Calculate Average, Minimum And Maximum in Excel

Step 3:

➦ Type the formula in Cell C15 which is given below-

=MAX(C3:C9)

➦ Then just hit the Enter button to find the maximum value.


Method 2: Apply AutoSum Tool to Evaluate Average, Minimum and Maximum in Excel

Here, we’ll do the same operation using the Excel AutoSum tool from the Home ribbon. First, I’ll show how to find the average.

Step 1:

➦ Activate Cell C13

➦ Click Home > Editing > AutoSum > Average

AutoSum Tool to Evaluate Average, Minimum And Maximum in Excel

Step 2:

➦ Then select the data range and click the Enter button.

Now to find minimum and maximum-

Click HOME > Editing > AutoSum > MIn/Max and then the other steps are the same.


Method 3:  Use Auto-Stats to Find Average, Minimum and Maximum in Excel

It is one of the simplest ways to find the average, minimum and maximum.

Steps:

➦ Just select the data range and Excel will automatically show the Average, Min, and Max values in the status bar of your sheet.

Auto-Stats to Find Average, Minimum And Maximum in Excel


Method 4: Create Pivot Table in Excel to Calculate Average Minimum And Maximum

In our last method, we’ll calculate average, minimum, and maximum by using the Pivot Table. A pivot table in Excel is an extraction or resumé of your original table with source data. A pivot table can provide quick answers to questions about your table.

Step 1:

➦ Click as follows: Insert > PivotTable

A dialog box will open up.

Pivot Table in Excel to Calculate Average Minimum And Maximum

Step 2:

➦ Select where you will create the table and set the location. I have selected Existing Worksheet and Cell E4 as the location.

➦ Press OK

A dialog box named ‘PivotTable Fields’ will appear.

Pivot Table in Excel to Calculate Average Minimum And Maximum

Step 3:

➦ Mark on Products and Price option in the field.

Pivot Table in Excel to Calculate Average Minimum And Maximum

Step 4:

➦ Now click:  Sum of Price > Value Field Settings.

Value Field Settings dialog box will appear.

Pivot Table in Excel to Calculate Average Minimum And Maximum

Step 5:

➦ Then select Average from the ‘Summarize Values By’ option and press OK

Pivot Table in Excel to Calculate Average Minimum And Maximum

See the image below and the average price is now showing in the table.

Step 6:

➦ Now to find the minimum or maximum just select Max/Min from the ‘Summarize Values By’ option and press OK


Conclusion

I hope all of the methods described above will be useful enough to calculate the average, minimum, and maximum in excel. Feel free to ask any questions in the comment section and please give me feedback.


Related Articles

How to Calculate VLOOKUP AVERAGE in Excel (6 Quick Ways)

How to Calculate Years in Excel from Today (4 Ways)

How to Calculate Difference Between Two Dates and Times in Excel

How to Calculate the Top 10 Percent in Excel (4 Ways)

How to Calculate Average Tenure of Employees in Excel

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Excel is an amazing softwear. Here i will post excel related useful articles. I am a graduate from Bangladesh University of Engineering and Technology. I love to learn new things and work with it. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo