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

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

- 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 Calculate Average Revenue in Excel

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

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

- 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 Calculate Sum & Average with Excel Formula

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

**Download Practice Workbook**

Download the practice workbook.

## Related Articles

- Average Attendance Formula in Excel
- How to Calculate Average, Minimum And Maximum in Excel
- How to Calculate Average of Averages in Excel
- How to Calculate Average True Range in Excel
- How to Calculate Average Percentage in Excel
- How to Calculate Average Percentage of Marks in Excel
- How to Calculate Class Average in Excel
- How to Calculate Average Share Price in Excel
- How to Calculate Average Length of Stay in Excel
- How to Calculate Average Price in Excel

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