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.

**Table of Contents**hide

## Download Practice Workbook

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

## 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 merit and demerits.

**📖 Merits:**

- Help a corporation set their goal
- Tracks the performance of that company
- Compare the performance reports within a short period,
- Resolve any unexpected issue regarding the product
- Figure out the top demandable season of any product
- Building a trustworthy relationship between the stakeholder and the management
- Attracting new investors

**📖 ****Demerits:**

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

## 8 Easy Methods to Calculate Average Quarterly Revenue in Excel

To demonstrate the approaches, we consider the dataset of the quarterly revenue report of a stationary company for **5** different items. The name 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 into the cell.

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

- Press
**Enter**.

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

Thus, we can say that our formula works perfectly, and we are able to 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 into the cell.

`=AVERAGE(C6:F6)`

- Then, press
**Enter**.

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

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

**Read More:** **How to Calculate Average Revenue in Excel (6 Easy Methods)**

### 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 into the cell.

`=AVERAGEA(C6:F6)`

- Press
**Enter**.

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

- You will get your desired result.

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

**Read More: ****[Fixed!] AVERAGE Formula Not Working in Excel (6 Solutions)**

### 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 into the cell.

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

- Next, press
**Enter**.

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

- You will get the result.

Therefore, we can say that our formula works properly, and we are able to 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**.

**Read More:** **Calculate the Average of an Array with VBA (Macro, UDF, and UserForm)**

**Similar Readings**

**Calculate Average of Multiple Columns in Excel (6 Methods)****How to Ignore #N/A Error When Getting Average in Excel****Calculate Average Numbers in Excel (9 Handy Methods)****How to Fix Divide by Zero Error for Average Calculation in Excel**

### 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 into the cell.

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

- Then, press
**Enter**.

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

- You will figure out the average value.

In the end, we can say that our formula works perfectly, and we are able to 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.

At last, we can say that our procedure works effectively, and we are able to calculate average quarterly revenue in Excel.

**Read More:** **How to Calculate Average of Multiple Ranges in Excel (3 Methods)**

### 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 into the cell.

`=SUM(C6:F6)/4`

- Now, press
**Enter**.

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

Thus, we can say that our formula works precisely, and we are able to 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 into the cell.

`=SUBTOTAL(9,C6:F6)/4`

- Then, press
**Enter**.

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

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

**Read More: ****How to Do Subtotal Average in Excel (5 Suitable Ways)**

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

Don’t forget to check our website, **ExcelDemy**, for several Excel-related problems and solutions. Keep learning new methods and keep growing!