How to Calculate Average Quarterly Revenue in Excel (8 Ways)

Get FREE Advanced Excel Exercises with Solutions!

Calculating the average is a common task in our regular professional life. Almost every day, we calculate the average of something according to our needs. In this article, we are going to show 8 unique methods to calculate average quarterly revenue in Excel. If you are also curious about it, download our practice workbook and follow us.


What Is Quarterly Revenue?

In a year, we have 12 months, and the combination of conjugated 3 months is called a quarter. So, when an organization publishes its income and expenses report as well as the revenue report for three months period is called a quarterly revenue report. It has both merits and demerits.

📖 Merits:

  1. Help a corporation set its goal
  2. Tracks the performance of that company
  3. Compare the performance reports within a short period,
  4. Resolve any unexpected issues regarding the product
  5. Figure out the top demandable season of any product
  6. Building a trustworthy relationship between the stakeholders and the management
  7. Attracting new investors

📖 Demerits:

  1. Provide the sales report for a short period. As a result, not possible to predict overall product demand,
  2. Display low amount of sales,
  3. Need lots of time to create,
  4. Not suitable for the industry where sales don’t fluctuate significantly.

How to Calculate Average Quarterly Revenue in Excel: 8 Ways

To demonstrate the approaches, we consider the dataset of the quarterly revenue report of a stationary company for 5 different items. The names of the items are in column B, and the 4 quarterly reports are in columns C, D, E, and F. So, our dataset is in the range of cell B6:F10. We will show the average quarterly revenue value in column G.

📚 Note:

All the operations of this article are accomplished by using the Microsoft Office 365 application.


1. Applying Conventional Formula

In our first approach, we will use a conventional formula to calculate average quarterly revenue in Excel. The steps of this method are given below:

📌 Steps:

  • First of all, select cell G6.
  • Now, write down the following formula in the cell.

=(C6+D6+E6+F6)/4

  • Press Enter.

Applying Conventional Formula to Calculate Average

  • Then, double-click on the Fill Handle icon to copy the formula up to cell G10.

  • You will get the average value of the quarterly revenue.

Applying Conventional Formula to Calculate Average Quarterly Revenue

Thus, we can say that our formula works perfectly, and we can calculate average quarterly revenue in Excel.

Read More: How to Calculate Monthly Average from Daily Data in Excel


2. Using AVERAGE Function

In this method, we are going to use the AVERAGE function to estimate average quarterly revenue in Excel. The steps of this process are given as follows:

📌 Steps:

  • First, select cell G6.
  • After that, write down the following formula in the cell.

=AVERAGE(C6:F6)

  • Then, press Enter.

Using AVERAGE Function

  • Now, double-click on the Fill Handle icon to copy the formula up to cell G10.

  • You will get the average value of the quarterly revenue.

Using AVERAGE Function to Calculate Average Quarterly Revenue

So, we can say that our formula works effectively, and we can calculate average quarterly revenue in Excel.

Read More: How to Calculate Average Revenue in Excel


3. Utilizing AVERAGEA Function

In this process, we will use the AVERAGEA function to evaluate average quarterly revenue in Excel. The steps of this procedure are shown below:

📌 Steps:

  • At first, select cell G6.
  • Then, write down the following formula in the cell.

=AVERAGEA(C6:F6)

  • Press Enter.

Utilizing AVERAGEA Function to Calculate Average Quarterly Revenue

  • Afterward, double-click on the Fill Handle icon to copy the formula up to cell G10.

  • You will get your desired result.

Utilizing AVERAGEA Function to Calculate Average

Hence, we can say that our formula works precisely, and we can calculate average quarterly revenue in Excel.

Read More: Moving Average Formula in Excel


4. Combining AVERAGE and LARGE Functions

Here, the AVERAGE and LARGE functions will help us to determine the average quarterly revenue in Excel. The steps of this case are shown as follows:

📌 Steps:

  • Firstly, select cell G6.
  • Write down the following formula in the cell.

=AVERAGE(LARGE(C6:F6,{1,2,3,4}))

  • Next, press Enter.

Combing AVERAGE and LARGE Functions to Calculate Average Quarterly Revenue

  • Then, double-click on the Fill Handle icon to copy the formula up to cell G10.

  • You will get the result.

Combing AVERAGE and LARGE Functions to Calculate Average

Therefore, we can say that our formula works properly, and we can calculate average quarterly revenue in Excel.

🔎 Breakdown of the Formula

We are breaking down the formula for cell G6.

👉 LARGE(C7:F7,{1,2,3,4}): The LARGE function returns 4523, 4326, 4215, and 4139.

👉 AVERAGE(LARGE(C6:F6,{1,2,3,4})): The AVERAGE function returns the average of the four numbers of the array and shows the final result. For this cell, the value is 5089.


5. Combination of AVERAGE and SMALL Functions

In the following method, we are going to use the AVERAGE and SMALL functions to calculate the average quarterly revenue in Excel. The procedure is explained below step-by-step:

📌 Steps:

  • In the beginning, select cell G6.
  • Next, write down the following formula in the cell.

=AVERAGE(SMALL(C6:F6,{1,2,3,4}))

  • Then, press Enter.

Combination of AVERAGE and SMALL Functions to Calculate Average Quarterly Revenue

  • After that, double-click on the Fill Handle icon to copy the formula up to cell G10.

  • You will figure out the average value.

Combination of AVERAGE and SMALL Functions to Calculate Average

In the end, we can say that our formula works perfectly, and we can calculate average quarterly revenue in Excel.

🔎 Breakdown of the Formula

We are breaking down the formula for cell G6.

👉 SMALL(C6:F6,{1,2,3,4}): The SMALL function returns 4910, 5035, 5180, and 5230.

👉 AVERAGE(SMALL(C6:F6,{1,2,3,4})): The AVERAGE function returns the average of the four numbers of the array and shows the final result. For this cell, the value is 5089.

Read More: How to Calculate Average Only for Cells with Values in Excel


6. Using AutoSum to Find Average Quickly

In the following procedure, we are going to estimate the average from the AutoSum command. It is the easiest approach to calculating the average quarterly revenue. The steps of this method are described below:

📌 Steps:

  • First of all, select the range of cells C6:G10.
  • Now, in the Home tab, select the drop-down arrow of the AutoSum > Average option from the Editing group.

  • You will get the average value of the quarterly revenue within a second.

Using AutoSum to Find Average Quickly to Calculate Average Quarterly Revenue

Finally, we can say that our procedure works effectively, and we can calculate average quarterly revenue in Excel.

Read More: How to Calculate Average of Multiple Ranges in Excel


7. Estimating Average by SUM Function

In the following approach, we will use the SUM function to determine the average quarterly revenue in Excel. The steps of this method are given below:

📌 Steps:

  • First, select cell G6.
  • After that, write down the following formula in the cell.

=SUM(C6:F6)/4

  • Now, press Enter.

Using SUM Function to Calculate Average Quarterly Revenue

  • Then, double-click on the Fill Handle icon to copy the formula up to cell G10.

  • You will figure out the average value of the quarterly revenue.

Estimating Average by SUM Function

Thus, we can say that our formula works precisely, and we can calculate average quarterly revenue in Excel.

Read More: How to Calculate Sum & Average with Excel Formula


8. Evaluating Average by SUBTOTAL Function

In the last method, we are going to use the SUBTOTAL function to calculate the average quarterly revenue in Excel. The steps of this method are explained as follows:

📌 Steps:

  • Firstly, select cell G6.
  • Now, write down the following formula in the cell.

=SUBTOTAL(9,C6:F6)/4

  • Then, press Enter.

Using SUBTOTAL Function to Calculate Average Quarterly Revenue

  • Afterward, double-click on the Fill Handle icon to copy the formula up to cell G10.

  • You will figure out the average value of the quarterly revenue.

Evaluating Average by SUBTOTAL Function

Finally, we can say that our formula works successfully, and we can calculate average quarterly revenue in Excel.

Read More: How to Do Subtotal Average in Excel


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to calculate average quarterly revenue in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Keep learning new methods and keep growing!


Related Articles


<< Go Back to Excel Average Formula Examples | How to Calculate Average in Excel | How to Calculate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo