---
title: "COUNT function in Excel: syntax and examples | ExcelSavvy"
description: "How to use COUNT in Excel and Google Sheets: count only the cells that hold numbers. Examples and a live drill."
canonical_url: "https://excelsavvy.com/functions/count"
meta:
  "og:description": "How to use COUNT in Excel and Google Sheets: count only the cells that hold numbers. Examples and a live drill."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09VTlQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBDT1VOVCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogY291bnQgb25seSB0aGUgY2VsbHMgdGhhdCBob2xkIG51bWJlcnMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09VTlQodmFsdWUxLCBbdmFsdWUyXSwgLi4uKQ%2Cp_Ii9mdW5jdGlvbnMvY291bnQi%2Cs_gEihGYj0ZDaBZZYV.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "COUNT function in Excel: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09VTlQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBDT1VOVCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogY291bnQgb25seSB0aGUgY2VsbHMgdGhhdCBob2xkIG51bWJlcnMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09VTlQodmFsdWUxLCBbdmFsdWUyXSwgLi4uKQ%2Cp_Ii9mdW5jdGlvbnMvY291bnQi%2Cs_gEihGYj0ZDaBZZYV.png"
---

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

# **The COUNT function**

Counts the cells that hold numbers (dates count too). Text, blanks and errors are not counted.

=

COUNT(

## **How to use COUNT**

COUNT answers one question: how many numbers are in this range? It is like counting the price tags on a shelf while skipping the labels that only have words on them. Dates count too, because Excel stores a date as a number.

Use COUNT when you want to know how many amounts, scores or dates you have, for example how many invoices have an amount filled in or how many students handed in a score. `**=COUNT(A2:A6)**` counts the cells in A2:A6 that hold a number. You can add more ranges or plain numbers: `**=COUNT(A2:A6,10)**` counts the numbers in A2:A6 and the 10 on top.

Text, empty cells and errors are not counted. That is what you want when a column mixes numbers with notes, but it surprises people when a list of names gives 0.

To count every cell that is filled, text included, use COUNTA. To count the empty cells, use COUNTBLANK. To count only the cells that meet a condition, such as sales over 300, use COUNTIF: `**=COUNTIF(C2:C6,">300")**`.

## **Syntax**

```
COUNT(value1, [value2], ...)
```

<dl><dt>**value1 **</dt>
<dd>The first value, cell or range.</dd>
<dt>**value2 **(optional)</dt>
<dd>More values or ranges.</dd></dl>

## **Examples**

C1=COUNT(A2:A6)

|  | A | B | C |
| --- | --- | --- | --- |
| 1 | Units |  | **3** |
| 2 | 4 |  | |
| 3 | n/a |  | |
| 4 | 7 |  | |
| 5 |  |  | |
| 6 | 2 |  | |

C1`=COUNT(<sup>1</sup>A2:A6,<sup>2</sup>10)`

|  | A | B | C |
| --- | --- | --- | --- |
| 1 | Units |  | **4** |
| 2 | 4 |  | |
| 3 | n/a |  | |
| 4 | 7 |  | |
| 5 |  |  | |
| 6 | 2 |  | |

**In plain words:** Count the numbers <sup>1</sup>in A2:A6 plus <sup>2</sup>the number 10.

## **Common COUNT mistakes**

- COUNT gives 0 on a list of names

  COUNT counts numbers only, so names, emails and other text are skipped. Use `**=COUNTA(A2:A6)**` to count every filled cell.
- COUNT is lower than the number of values I can see

  Some of the numbers are stored as text, often after a paste or import, so COUNT skips them. Compare with `**=COUNTA(A2:A6)**`: if COUNTA is higher and the cells look like numbers, they are text. Convert them with `**=VALUE(A2)**` in a helper column.
- COUNT counts zeros and dates I did not want

  A zero is a number and a date is a number, so both are counted. To count only values above zero, use `**=COUNTIF(A2:A6,">0")**`.

## **Practice COUNT**

- [**1****Count numbers with COUNT**→](https://excelsavvy.com/practice/count/count-numbers)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)

## **Questions**

<details>

<summary>

### What is the difference between COUNT and COUNTA?

</summary>

COUNT counts only cells with numbers, dates included. COUNTA counts every cell that is not empty, including text, TRUE or FALSE, and errors.

</details>

<details>

<summary>

### How do I count cells with text in Excel?

</summary>

COUNT skips text, so use COUNTIF with a wildcard: =COUNTIF(A2:A10,"\*") counts the cells that hold text. To count a specific word, put it in the criteria, like =COUNTIF(A2:A10,"Shoes").

</details>

<details>

<summary>

### Does COUNT count dates?

</summary>

Yes. Excel and Google Sheets store a date as a number, so a real date is counted. A date typed as text, such as one with a stray apostrophe, is not.

</details>

<details>

<summary>

### How do I count the empty cells in a range?

</summary>

Use COUNTBLANK: =COUNTBLANK(A2:A10). It also counts cells that only hold an empty text result from a formula.

</details>

## **Related functions**

- [**COUNTA**](https://excelsavvy.com/functions/counta)
- [**COUNTBLANK**](https://excelsavvy.com/functions/countblank)
- [**COUNTIF**](https://excelsavvy.com/functions/countif)

```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/count#webpage","dateModified":"2026-11-16","description":"How to use COUNT in Excel and Google Sheets: count only the cells that hold numbers. Examples and a live drill.","name":"COUNT function in Excel: syntax and examples","url":"https://excelsavvy.com/functions/count","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/count#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/count#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/count#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/count#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/count#/schema/question/4"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/count"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/count#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":"COUNT function in Excel: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/functions/count#article","dateModified":"2026-11-16","description":"How to use COUNT in Excel and Google Sheets: count only the cells that hold numbers. Examples and a live drill.","headline":"COUNT function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09VTlQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBDT1VOVCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogY291bnQgb25seSB0aGUgY2VsbHMgdGhhdCBob2xkIG51bWJlcnMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09VTlQodmFsdWUxLCBbdmFsdWUyXSwgLi4uKQ%2Cp_Ii9mdW5jdGlvbnMvY291bnQi%2Cs_gEihGYj0ZDaBZZYV.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/count#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/count#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/count#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is the difference between COUNT and COUNTA?","acceptedAnswer":{"@type":"Answer","text":"COUNT counts only cells with numbers, dates included. COUNTA counts every cell that is not empty, including text, TRUE or FALSE, and errors."}},{"@id":"https://excelsavvy.com/functions/count#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I count cells with text in Excel?","acceptedAnswer":{"@type":"Answer","text":"COUNT skips text, so use COUNTIF with a wildcard: =COUNTIF(A2:A10,\"*\") counts the cells that hold text. To count a specific word, put it in the criteria, like =COUNTIF(A2:A10,\"Shoes\")."}},{"@id":"https://excelsavvy.com/functions/count#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Does COUNT count dates?","acceptedAnswer":{"@type":"Answer","text":"Yes. Excel and Google Sheets store a date as a number, so a real date is counted. A date typed as text, such as one with a stray apostrophe, is not."}},{"@id":"https://excelsavvy.com/functions/count#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I count the empty cells in a range?","acceptedAnswer":{"@type":"Answer","text":"Use COUNTBLANK: =COUNTBLANK(A2:A10). It also counts cells that only hold an empty text result from a formula."}},{"@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_~Q09VTlQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBDT1VOVCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogY291bnQgb25seSB0aGUgY2VsbHMgdGhhdCBob2xkIG51bWJlcnMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09VTlQodmFsdWUxLCBbdmFsdWUyXSwgLi4uKQ%2Cp_Ii9mdW5jdGlvbnMvY291bnQi%2Cs_gEihGYj0ZDaBZZYV.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09VTlQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBDT1VOVCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogY291bnQgb25seSB0aGUgY2VsbHMgdGhhdCBob2xkIG51bWJlcnMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09VTlQodmFsdWUxLCBbdmFsdWUyXSwgLi4uKQ%2Cp_Ii9mdW5jdGlvbnMvY291bnQi%2Cs_gEihGYj0ZDaBZZYV.png"}]}
```

## Sitemap

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