How to Calculate the Average Quarterly Revenue in Excel – 8 Methods

 

What Is the Quarterly Revenue?

When an organization publishes its income and expenses report as well as the revenue report for a three months period, it is called a quarterly revenue report.

Consider the dataset of the quarterly revenue report of a stationary company for 5 different items.


Method 1 – Applying a Conventional Formula

Steps:

  • Select G6.
  • Enter the following formula in the cell.

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

  • Press Enter.

Applying Conventional Formula to Calculate Average

  • Drag down the Fill Handle to see the result in the rest of the cells.

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

Applying Conventional Formula to Calculate Average Quarterly Revenue

 

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


Method 2 – Using the AVERAGE Function

Steps:

  • Select G6.
  • Enter the following formula in the cell.

=AVERAGE(C6:F6)

  • Press Enter.

Using AVERAGE Function

  • Drag down the Fill Handle to see the result in the rest of the cells.

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

Using AVERAGE Function to Calculate Average Quarterly Revenue

 

Read More: How to Calculate Average Revenue in Excel


Method 3 – Utilizing the AVERAGEA Function

Use the AVERAGEA function.

Steps:

  • Select G6.
  • Enter the following formula in the cell.

=AVERAGEA(C6:F6)

  • Press Enter.

Utilizing AVERAGEA Function to Calculate Average Quarterly Revenue

  • Drag down the Fill Handle to see the result in the rest of the cells.

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

Utilizing AVERAGEA Function to Calculate Average

 

Read More: Moving Average Formula in Excel


Method 4 – Combining the AVERAGE and the LARGE Functions

Use the AVERAGE and LARGE functions.

Steps:

  • Select G6.
  • Enter the following formula in the cell.

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

  • Press Enter.

Combing AVERAGE and LARGE Functions to Calculate Average Quarterly Revenue

  • Drag down the Fill Handle to see the result in the rest of the cells.

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

Combing AVERAGE and LARGE Functions to Calculate Average

Formula Breakdown

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

AVERAGE(LARGE(C6:F6,{1,2,3,4})):  returns the average of the four numbers of the array and shows the final result: 5089.


Method 5 – Combining the AVERAGE and the SMALL Functions

Use the AVERAGE and the SMALL functions.

Steps:

  • Select G6.
  • Enter the following formula in the cell.

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

  • Press Enter.

Combination of AVERAGE and SMALL Functions to Calculate Average Quarterly Revenue

  • Drag down the Fill Handle to see the result in the rest of the cells.

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

Combination of AVERAGE and SMALL Functions to Calculate Average

Formula Breakdown

SMALL(C6:F6,{1,2,3,4}):  returns 4910, 50355180, and 5230.

AVERAGE(SMALL(C6:F6,{1,2,3,4})):  returns the average of the four numbers of the array and shows the final result: 5089.


Method 6 – Using the AutoSum to Find the Average

Use the AutoSum command.

Steps:

  • Select C6:G10.
  • In the Home tab, select AutoSum > Average in Editing.

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

Using AutoSum to Find Average Quickly to Calculate Average Quarterly Revenue

 

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


Method 7 – Estimating the Average with the SUM Function

Use the SUM function.

Steps:

  • Select G6.
  • Enter the following formula in the cell.

=SUM(C6:F6)/4

  • Press Enter.

Using SUM Function to Calculate Average Quarterly Revenue

  • Drag down the Fill Handle to see the result in the rest of the cells.

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

Estimating Average by SUM Function

 

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


Method 8 – Calculating the Average with the SUBTOTAL Function

Use the SUBTOTAL function.

Steps:

  • Select G6.
  • Enter the following formula in the cell.

=SUBTOTAL(9,C6:F6)/4

  • Press Enter.

Using SUBTOTAL Function to Calculate Average Quarterly Revenue

  • Drag down the Fill Handle to see the result in the rest of the cells.

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

Evaluating Average by SUBTOTAL Function

 

Read More: How to Do Subtotal Average in Excel


Download Practice Workbook

Download the practice workbook.


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
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