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.

• 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.

Method 2 – Using the AVERAGE Function

Steps:

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

=AVERAGE(C6:F6)

• Press Enter.

• 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.

Method 3 – Utilizing the AVERAGEA Function

Steps:

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

=AVERAGEA(C6:F6)

• Press Enter.

• 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.

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.

• 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.

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.

• 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.

FormulaÂ Breakdown

SMALL(C6:F6,{1,2,3,4}): Â returns 4910, 5035,Â 5180,Â 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.

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.

• 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.

Method 8 – Calculating the Average with the SUBTOTAL Function

Steps:

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

=SUBTOTAL(9,C6:F6)/4

• Press Enter.

• 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.

Read More: How to Do Subtotal Average in Excel

Related Articles

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

Advanced Excel Exercises with Solutions PDF