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.

How to Calculate Average Sales in Excel


Download Practice Workbook


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.

How to Calculate Average Sales in Excel

  • Sequentially, select the range (i.e. D5:D10).

  • Finally, press ENTER and we have our Average Sales.

How to Calculate Average Sales in Excel


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.

How to Calculate Average Sales in Excel

Thus, we can calculate average sales in Excel.


Similar Readings


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.

How to Calculate Average Sales in Excel


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.

How to Calculate Average Sales in Excel

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.

How to Calculate Average Sales in Excel

Read More: How to Calculate Annual Sales in Excel (4 Useful Methods)


Practice Section

For more expertise, you can practice here.

How to Calculate Average Sales in Excel


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

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

Leave a reply

ExcelDemy
Logo