Ways to count cells in a range of data

Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. The following procedures show you how.

Do any of the following:

Count cells that are not empty

  1. Select the cell where you want the result to appear.

  2. On the Formulas tab, click Insert, point to Statistical and then click COUNTA.

  3. Select the range of cells that you want, and then press RETURN.

Count cells that contain numbers

  1. Select the cell where you want the result to appear.

  2. On the Formulas tab, click Insert, point to Statistical and then click COUNT.

  3. Select the range of cells that you want, and then press RETURN.

Count cells that are blank

  1. Select the cell where you want the result to appear.

  2. On the Formulas tab, click Insert, point to Statistical and then click COUNTBLANK.

  3. Select the range of cells that you want, and then press RETURN.

Count cells that meet criteria you enter

  1. Select the cell where you want the result to appear.

  2. On the Formulas tab, click Formula Builder.

  3. In the list of functions, double-click COUNTIF.

  4. Click in the range box, and then select the range of cells that you want.

  5. In the criteria box, enter your chosen criterion and then press RETURN.

    Tip: To enter more than one criterion, use the COUNTIFS function instead.

See also

Count unique values among duplicates

Count numbers greater than or less than a number

Count how often a value occurs

COUNT function

COUNTA function

COUNTBLANK function

COUNTIF function

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×