Chat with us, powered by LiveChat

COUNT Function in Excel

How to Use the COUNT Function in Excel

Excel’s COUNT functions can help you count cells with numbers, text, or blank cells. Excel actually has a small family of COUNT functions, but the most useful are:

  • COUNT: Counts cells that contain numbers; blank cells and cells with text aren’t counted. Syntax: = COUNT(A2:A10).
  • COUNTA: Counts cells that contain any kind of data, including numbers and text. Syntax: = COUNTA(A2:A10).
  • COUNTBLANK: Counts blank or empty cells. Syntax: = COUNTBLANK(A2:A10).

Create a Count Formula

The COUNT function counts cells that contain numbers; blank cells and cells with text aren't included.

  1. Click in the cell where you want to add the formula.
  2. Click the AutoSum button list arrow.
  3. Select Count Numbers.
    Create a Count Formula
  4. If necessary, select the desired cell range.
  5. Click Enter or press the Enter key.
    Create a Count Formula

Excel displays the number of cells that contain numbers in the range.

FREE Quick Reference

Click to Download