20 examples of how to use the AVERAGE function

 Here are 20 examples of how to use the AVERAGE function in Excel, including sample data and formulas. The AVERAGE function calculates the arithmetic mean of a range of numbers.

---

Example 1: Basic AVERAGE

Data:
A1: 10
A2: 20
A3: 30

Formula:
=AVERAGE(A1:A3)

Result:
20

---

Example 2: AVERAGE with Blank Cells

Data:
A1: 5
A2: (blank)
A3: 15

Formula:
=AVERAGE(A1:A3)

Result:
10

---

Example 3: AVERAGE with Text (Ignored)

Data:
A1: 10
A2: "Text"
A3: 20

Formula:
=AVERAGE(A1:A3)

Result:
15

---

Example 4: AVERAGE with Zero

Data:
A1: 5
A2: 0
A3: 10

Formula:
=AVERAGE(A1:A3)

Result:
5

---

Example 5: AVERAGE with Negative Numbers

Data:
A1: 10
A2: -20
A3: 30

Formula:
=AVERAGE(A1:A3)

Result:
6.6667

---

Example 6: AVERAGE of a Row

Data:
A1: 5, B1: 10, C1: 15

Formula:
=AVERAGE(A1:C1)

Result:
10

---

Example 7: AVERAGE of Non-Adjacent Cells

Data:
A1: 10, B1: 20, C1: 30, D1: 40

Formula:
=AVERAGE(A1, C1)

Result:
20

---

Example 8: AVERAGE with Logical Values

Data:
A1: TRUE, A2: 10, A3: FALSE

Formula:
=AVERAGE(A1:A3)

Result:
10

---

Example 9: AVERAGE with Mixed Data

Data:
A1: 10, A2: "Text", A3: 20, A4: 0

Formula:
=AVERAGE(A1:A4)

Result:
10

---

Example 10: AVERAGE of a Column

Data:
A1: 5, A2: 10, A3: 15

Formula:
=AVERAGE(A1:A3)

Result:
10

---

Example 11: AVERAGE with Decimals

Data:
A1: 1.5, A2: 2.5, A3: 3.5

Formula:
=AVERAGE(A1:A3)

Result:
2.5

---

Example 12: AVERAGE with Large Numbers

Data:
A1: 1000, A2: 2000, A3: 3000

Formula:
=AVERAGE(A1:A3)

Result:
2000

---

Example 13: AVERAGE with Fractions

Data:
A1: 1/2, A2: 1/4, A3: 1/8

Formula:
=AVERAGE(A1:A3)

Result:
0.2917

---

Example 14: AVERAGE with Dates (Serial Numbers)

Data:
A1: 01/01/2023, A2: 01/02/2023, A3: 01/03/2023

Formula:
=AVERAGE(A1:A3)

Result:
01/02/2023

---

Example 15: AVERAGE with Time

Data:
A1: 1:00, A2: 2:00, A3: 3:00

Formula:
=AVERAGE(A1:A3)

Result:
2:00

---

Example 16: AVERAGE with Mixed Positive and Negative Numbers

Data:
A1: 10, A2: -5, A3: 15

Formula:
=AVERAGE(A1:A3)

Result:
6.6667

---

Example 17: AVERAGE with a Named Range

Data:
A1: 10, A2: 20, A3: 30
Named Range: MyRange = A1:A3

Formula:
=AVERAGE(MyRange)

Result:
20

---

Example 18: AVERAGE with a Filtered Range

Data:
A1: 10, A2: 20, A3: 30
Filtered to show only A1 and A3

Formula:
=SUBTOTAL(101, A1:A3)

Result:
20

---

Example 19: AVERAGE with Errors (Ignored)

Data:
A1: 10, A2: #DIV/0!, A3: 20

Formula:
=AVERAGE(A1:A3)

Result:
15

---

Example 20: AVERAGE with Multiple Ranges

Data:
A1: 10, A2: 20, B1: 30, B2: 40

Formula:
=AVERAGE(A1:A2, B1:B2)

Result:
25