Sometimes we may need to average numbers from a column in Excel. Average means the mean value of the input numbers. We have to sum the numbers first and then divide the sum by the number of inputs to **get an average**. This article will discuss methods to average a column in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## 7 Methods to Average a Column in Excel

We can find the average of numbers using different methods in Excel. 7 such simple and efficient methods to average a column are given here.

### Method 1: Using AVERAGE Function for Column Average

Excel has an in-built **AVERAGE** function to do the average. Here we will discuss the method in steps.

**Step 1: **We have to select the cell where we want to put the average.

**Step 2: **We have to enter the cell and write the formula given below.

`=AVERAGE(C6:C9)`

Here, **C6:C9 **is the range for input numbers.

**Step 3: **We need to enter the formula in the cell and use **Fill Handle **to copy the formula to the cells besides.

We will see the results for each column.

This method also works for percentage input.

**Read More: ****How to Calculate Average of Multiple Ranges in Excel (3 Methods)**

### Method 2: Column Average with Blanks and Texts

If we have text as input, we can use the **AVERAGEA** function instead of the **AVERAGE **function. Here the text input will be counted as 1 and blank cells will be ignored. We are showing the steps below.

**Step 1: **We have to select the cell where we’ll average the inputs.

**Step 2: ** We need to write the formula given below in the cell.

`=AVERAGEA(C6:C9)`

Here, **C6:C9 **is the range for input.

**Step 3: **We have to enter the formula in the cell and use **Fill Handle **to copy the formula to the cells besides.

We can see, the results are different than the previous method.

**Read More: ****How to Calculate Class Average in Excel (6 Easiest Methods)**

**Similar Readings**

**How to Determine Triple Exponential Moving Average in Excel****Calculate Percentage above Average in Excel (3 Easy Ways)****How to Calculate Exponential Moving Average in Excel****Generate Moving Average in Excel Chart (4 Methods)****How to Calculate VLOOKUP AVERAGE in Excel (6 Quick Ways)**

### Method 3: Average of Top Numbers in a Column

We may need to average the top few numbers of the input range. In that case, we will use the **LARGE **function in addition to the **AVERAGE **function. The steps are given below.

**Step 1: **We have to select the cell where we want to calculate the result.

**Step 2: **We have to write the formula given below to the cell.

`=AVERAGE(LARGE(C6:C9, {1,2,3}))`

Here,** C6:C9 **is the range for input, and **{1,2,3} **denotes we will take the top 3 numbers.

**Step 3: **We enter the formula in the cell and use **Fill Handle **to copy the formula in the cells besides.

**Read More: ****How to Calculate Average of Multiple Columns in Excel (6 Methods)**

### Method 4: Average of Bottom Numbers in a Column

Instead of the average of top numbers, we may want the average of a few bottom numbers. We will use the **SMALL **function additionally. We will show the steps below.

**Step 1: **We need to select the cell where we will show the result.

**Step 2: **We have to write the formula given below in the cell.

`=AVERAGE(SMALL(C6:C9, {1,2,3}))`

Here, **C6:C9 **is the range for input, and **{1,2,3} **denotes we will take the bottom 3 numbers.

**Step 3: **We need to enter the formula into the cell and use **Fill Handle **to copy the formula to the cells besides.

We can see the result in all cells.

**Read More: ****Calculate the Average of an Array with VBA (Macro, UDF, and UserForm)**

### Method 5: Using Excel AVERAGEIF to Average with Criteria

We can also average numbers if certain criteria are fulfilled. Here we will use the **AVERAGEIF **function. We will show the steps to do that below.

**Step 1: **We have to select the cell where we will show the result.

**Step 2: **We have to enter the cell and write the following formula.

`=AVERAGEIF(C6:C9, ">70")`

Here, **C6:C9 **is the range, and **“>70” **is the criteria.

**Step 3: **We need to enter the formula in the cell and use **AutoFill **to copy the formula to the cells besides.

We can see the result in all cells.

**Read More: ****How to Calculate Average, Minimum And Maximum in Excel (4 Easy Ways)**

**Similar Readings**

**How to Exclude a Cell in Excel AVERAGE Formula (4 Methods)****[Fixed!] AVERAGE Formula Not Working in Excel (6 Solutions)****How to Calculate Average Percentage Change in Excel (3 Simple Ways)****Calculate Average in Excel Excluding 0 (2 Methods)****Moving Average Formula in Excel (8 Uses with Examples)**

### Method 6: Using MEDIAN Function for Column Average

Instead of arithmetic mean we can also find the median of a few numbers as average. We will use the **MEDIAN **function in this case. We have to follow the steps below to find the median.

**Step 1: **We have to select the cell where we’ll show the result.

**Step 2: **We need to write the formula given below to the cell.

`=MEDIAN(C6:C9)`

Here, **C6:C9 **is the range for input.

**Step 3: **We have to enter the formula in the cell and copy the formula to the cells beside by using **Fill Handle**.

We can see the result in all cells.

**Read More: ****How to Calculate Average Percentage of Marks in Excel (Top 4 Methods)**

### Method 7: Column Average Using MODE Function

The mode can be a replacement for average sometimes. We will use the **MODE **function in Excel to do that. We will show the steps below.

**Step 1: **We have to select the cell to display the result.

**Step 2: **We have to enter the cell and write the formula given below.

`=MODE(C6:C9)`

Here, **C6:C9 **is the range for input.

**Step 3: **We have to enter the formula in the cell and use **Fill Handle **to copy the formula to the cells besides.

We can see the result in all cells. *There will be no mode if there is no repetition of the input number.*

**Read More: ****How to Average Every Nth Row in Excel (3 Ways)**

## Conclusion

Average of numbers is a very useful tool for mathematical calculation. In Excel, we can find the average of a column using different methods. In this article, we have shown 7 such simple methods to average a column in Excel. Hope the article will help you. If you have any suggestions regarding the methods, please let us know by comment.

## Related Articles

**How to Calculate Daily Average from Hourly Data in Excel****Calculate Average Growth Rate in Excel (3 Easy Methods)****How to Calculate Average of Averages in Excel (with Easy Steps)****Calculate Average Only for Cells with Values in Excel****How to Calculate Average of Text in Excel (2 Ways)****Average Attendance Formula in Excel (5 Ways)****How to Calculate Centered Moving Average in Excel (2 Examples)**