In this Excel tutorial, you will learn various examples of how to apply formula to calculate average in Excel. We will discuss how to calculate the average marks of students and the average revenue using the **AVERAGE** and **AVERAGEIF** functions in Excel.

**Table of Contents**Expand

## How to Calculate Average Marks of Students Using Formula in Excel

Consider the following dataset. We have a list of marks in 3 different subjects for some students. We want to calculate their average marks. We can use the **AVERAGE** function for this.

Apply the following formula in cell **F6**, press the Enter key, and then drag down the **Fill Handle** icon to copy the formula in the remaining cells.

`=AVERAGE(C6:E6)`

## How to Calculate Average Revenue Using Formula in Excel

Another common example of using the average formula is calculating average revenue. Consider the following dataset. We have a list of sales outlets, their locations, and revenues. We will calculate the average revenue of outlets that are located in Texas. We can use the **AVERAGEIF** function for this.

Apply the following formula in cell **C20** and press the **Enter** key.

`=AVERAGEIF(C6:C16,C19,D6:D16)`

This concludes our article on useful examples of using average formula in Excel. We discussed two of the most common examples of calculating average using the **AVERAGE** and **AVERAGEIF** functions in Excel. We hope this article was helpful to you. Let us know your feedback.

## Excel Average Formula Examples: Knowledge Hub

- Average Attendance Formula in Excel
- How to Calculate Average True Range in Excel
- How to Calculate Class Average in Excel
- How to Calculate Average Revenue in Excel
- How to Calculate Average Quarterly Revenue in Excel
- How to Calculate Average Share Price
- How to Calculate Average Length of Stay in Excel

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