---
title: "Average in Excel: how to use the AVERAGE function"
description: "How to calculate an average in Excel with AVERAGE: of a range, with a condition, without zeros and rounded. With examples and exercises."
canonical_url: "https://excelsavvy.com/functions/average"
meta:
  "og:description": "How to calculate an average in Excel with AVERAGE: of a range, with a condition, without zeros and rounded. With examples and exercises."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~QXZlcmFnZSBpbiBFeGNlbDogaG93IHRvIHVzZSB0aGUgQVZFUkFHRSBmdW5jdGlvbg%2Cdescription_~SG93IHRvIGNhbGN1bGF0ZSBhbiBhdmVyYWdlIGluIEV4Y2VsIHdpdGggQVZFUkFHRTogb2YgYSByYW5nZSwgd2l0aCBhIGNvbmRpdGlvbiwgd2l0aG91dCB6ZXJvcyBhbmQgcm91bmRlZC4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~QVZFUkFHRShudW1iZXIxLCBbbnVtYmVyMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvYXZlcmFnZSI%2Cs_fqksOAzL-qbw_JcI.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Average in Excel: how to use the AVERAGE function"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~QXZlcmFnZSBpbiBFeGNlbDogaG93IHRvIHVzZSB0aGUgQVZFUkFHRSBmdW5jdGlvbg%2Cdescription_~SG93IHRvIGNhbGN1bGF0ZSBhbiBhdmVyYWdlIGluIEV4Y2VsIHdpdGggQVZFUkFHRTogb2YgYSByYW5nZSwgd2l0aCBhIGNvbmRpdGlvbiwgd2l0aG91dCB6ZXJvcyBhbmQgcm91bmRlZC4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~QVZFUkFHRShudW1iZXIxLCBbbnVtYmVyMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvYXZlcmFnZSI%2Cs_fqksOAzL-qbw_JcI.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **The AVERAGE function**

Returns the mean: the sum of the numbers divided by how many there are. Blank cells and text are skipped.

=

AVERAGE(

## **Syntax**

```
AVERAGE(number1, [number2], ...)
```

<dl><dt>**number1 **</dt>
<dd>The first number, cell or range.</dd>
<dt>**number2 **(optional)</dt>
<dd>More numbers or ranges.</dd></dl>

## **Examples**

E1=AVERAGE(C2:C6)

|  | A | B | C | D | E |
| --- | --- | --- | --- | --- | --- |
| 1 | Region | Product | Sales |  | **330** |
| 2 | North | Shoes | 500 |  | |
| 3 | South | Shoes | 300 |  | |
| 4 | North | Bags | 250 |  | |
| 5 | North | Shoes | 420 |  | |
| 6 | South | Bags | 180 |  | |

B1=AVERAGE(2,4,9)

|  | A | B |
| --- | --- | --- |
| 1 |  | **5** |

## **Practice AVERAGE**

- [**1****Find the average with AVERAGE**→](https://excelsavvy.com/practice/average/average-function)
- [**2****AVERAGE skips blank cells**→](https://excelsavvy.com/practice/average/average-blank-cells)
- [**3****Round an average with ROUND**→](https://excelsavvy.com/practice/average/round-an-average)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**How to make a graph in Excel: column, line and pie charts step by step**](https://excelsavvy.com/learn/excel-charts)

## **Questions**

<details>

<summary>

### Does AVERAGE count blank cells?

</summary>

No. Blank cells and text are skipped, so they do not pull the average down. A cell that holds 0 does count.

</details>

<details>

<summary>

### How do I calculate an average with a condition?

</summary>

Use AVERAGEIF. =AVERAGEIF(A2:A6,"North",C2:C6) gives the average of sales in the North region. For several conditions, use AVERAGEIFS.

</details>

<details>

<summary>

### How do I average without zeros?

</summary>

Use AVERAGEIF with the condition "&lt;&gt;0", as in =AVERAGEIF(C2:C6,"&lt;&gt;0"). Cells that hold 0 no longer count, and blank cells are skipped as always.

</details>

<details>

<summary>

### How do I round an average?

</summary>

Wrap AVERAGE in ROUND, as in =ROUND(AVERAGE(C2:C6),1) for one decimal place. To show fewer decimals without changing the number, use Decrease Decimal on the Home tab.

</details>

<details>

<summary>

### What is the difference between the average and the median?

</summary>

The average is the sum divided by the count. The median is the middle number when the numbers are in order, and one very large number does not pull it up. Use MEDIAN to find it.

</details>

## **Related functions**

- [**AVERAGEIF**](https://excelsavvy.com/functions/averageif)
- [**MEDIAN**](https://excelsavvy.com/functions/median)
- [**SUM**](https://excelsavvy.com/functions/sum)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/functions/average#webpage","description":"How to calculate an average in Excel with AVERAGE: of a range, with a condition, without zeros and rounded. With examples and exercises.","name":"Average in Excel: how to use the AVERAGE function","url":"https://excelsavvy.com/functions/average","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/average#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/average#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/average#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/average#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/average#/schema/question/4"},{"@id":"https://excelsavvy.com/functions/average#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/average"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/average#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"Average in Excel: how to use the AVERAGE function","position":3}]},{"@id":"https://excelsavvy.com/functions/average#article","description":"How to calculate an average in Excel with AVERAGE: of a range, with a condition, without zeros and rounded. With examples and exercises.","headline":"Average in Excel: how to use the AVERAGE function","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~QXZlcmFnZSBpbiBFeGNlbDogaG93IHRvIHVzZSB0aGUgQVZFUkFHRSBmdW5jdGlvbg%2Cdescription_~SG93IHRvIGNhbGN1bGF0ZSBhbiBhdmVyYWdlIGluIEV4Y2VsIHdpdGggQVZFUkFHRTogb2YgYSByYW5nZSwgd2l0aCBhIGNvbmRpdGlvbiwgd2l0aG91dCB6ZXJvcyBhbmQgcm91bmRlZC4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~QVZFUkFHRShudW1iZXIxLCBbbnVtYmVyMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvYXZlcmFnZSI%2Cs_fqksOAzL-qbw_JcI.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/average#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/average#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/average#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Does AVERAGE count blank cells?","acceptedAnswer":{"@type":"Answer","text":"No. Blank cells and text are skipped, so they do not pull the average down. A cell that holds 0 does count."}},{"@id":"https://excelsavvy.com/functions/average#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I calculate an average with a condition?","acceptedAnswer":{"@type":"Answer","text":"Use AVERAGEIF. =AVERAGEIF(A2:A6,\"North\",C2:C6) gives the average of sales in the North region. For several conditions, use AVERAGEIFS."}},{"@id":"https://excelsavvy.com/functions/average#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I average without zeros?","acceptedAnswer":{"@type":"Answer","text":"Use AVERAGEIF with the condition \"\u003C>0\", as in =AVERAGEIF(C2:C6,\"\u003C>0\"). Cells that hold 0 no longer count, and blank cells are skipped as always."}},{"@id":"https://excelsavvy.com/functions/average#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I round an average?","acceptedAnswer":{"@type":"Answer","text":"Wrap AVERAGE in ROUND, as in =ROUND(AVERAGE(C2:C6),1) for one decimal place. To show fewer decimals without changing the number, use Decrease Decimal on the Home tab."}},{"@id":"https://excelsavvy.com/functions/average#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"What is the difference between the average and the median?","acceptedAnswer":{"@type":"Answer","text":"The average is the sum divided by the count. The median is the middle number when the numbers are in order, and one very large number does not pull it up. Use MEDIAN to find it."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~QXZlcmFnZSBpbiBFeGNlbDogaG93IHRvIHVzZSB0aGUgQVZFUkFHRSBmdW5jdGlvbg%2Cdescription_~SG93IHRvIGNhbGN1bGF0ZSBhbiBhdmVyYWdlIGluIEV4Y2VsIHdpdGggQVZFUkFHRTogb2YgYSByYW5nZSwgd2l0aCBhIGNvbmRpdGlvbiwgd2l0aG91dCB6ZXJvcyBhbmQgcm91bmRlZC4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~QVZFUkFHRShudW1iZXIxLCBbbnVtYmVyMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvYXZlcmFnZSI%2Cs_fqksOAzL-qbw_JcI.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~QXZlcmFnZSBpbiBFeGNlbDogaG93IHRvIHVzZSB0aGUgQVZFUkFHRSBmdW5jdGlvbg%2Cdescription_~SG93IHRvIGNhbGN1bGF0ZSBhbiBhdmVyYWdlIGluIEV4Y2VsIHdpdGggQVZFUkFHRTogb2YgYSByYW5nZSwgd2l0aCBhIGNvbmRpdGlvbiwgd2l0aG91dCB6ZXJvcyBhbmQgcm91bmRlZC4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~QVZFUkFHRShudW1iZXIxLCBbbnVtYmVyMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvYXZlcmFnZSI%2Cs_fqksOAzL-qbw_JcI.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
