# How to Calculate Average Sales in Excel (5 Simple Approaches)

Average estimation is a very common factor in our everyday life. In the business section, it is an important factor to summarize the production or sales over a certain period. I am going to discuss about 5 simple approaches on how to calculate Average sales in Excel.
For more clarification, I am going to use a Dataset with Serial No, Sales Representatives, and Sales columns.

## 5 Simple Approaches to Calculate Average Sales in Excel

### 1. Applying Average Command to Calculate Average Sales

Using the Average command from the Home tab is the simplest way to calculate Average sales in Excel.

Steps:

• First of all, select a cell to find the Average (i.e. D12). • Next, go to the Home tab.
• From there, click on the AutoSum options from the ribbon.
• Then, choose the Average command. • Sequentially, select the range (i.e. D5:D10). • Finally, press ENTER and we have our Average Sales. ### 2. Using AVERAGE Function to Calculate Average Sales

We can use the AVERAGE Function to determine the Average Sales. It is one of the simplest ways to calculate Average Sales.

Steps:

• Pick a cell first (i.e. D12).
• Input the following formula:
`=AVERAGE(D5:D10)`

Here, the AVERAGE Function is applied to calculate the average value between cells D5 to D10. • Hit ENTER to finish the process. Thus, we can calculate average sales in Excel.

### 3. Arithmetic Formula to Calculate Average Sales

Average is actually the median value of a set of data. Mathematically, it is calculated by dividing the sum of some data by the number of data. We can use this arithmetic formula to calculate average sales.

Steps:

• Choose a cell for the calculation (i.e. D12).
• Apply the following formula:
`=SUM(D5:D10)/6`

Here, the average sales is calculated by dividing the summation of cells D5:D10 by the number of cells added. • Now, press ENTER to have the output.

### 4. Applying AVERAGEIF Functions to Calculate Average Sales

AVERAGEIF is another effective function with that we can calculate the average under certain conditions.

Steps:

• Select a cell for calculation (i.e. D12).
• Now, input the formula mentioned below:
`=AVERAGEIF(D5:D10, "April", E5:E10)`

Here, I have calculated the sales average for April month. • Hit ENTER. Now, we have the average of the sales in April month.

### 5. Calculating Monthwise Average Sales

The month-wise average sales is another very beneficial and common form of pattern used in industries. We can also calculate average sales through this pattern.

Steps:

• Use the following formula to calculate average sales month-wise:
`=D5/12`

Here, the Total sales value of 2016 in cell D5 is divided by the number of months in a year. • Now, press ENTER.  ## Practice Section

For more expertise, you can practice here. ## Conclusion

In this article, I have tried to articulate 5 simple approaches on how to calculate Average sales in Excel. I hope it will be helpful for all. For any further questions, comment below. For more information regarding Excel, you can visit our Exceldemy site.

## Related Articles #### Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts 