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.

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

  2. On the Formulas tab, click More Functions, point to Statistical, and then click one of the following functions:

    • COUNTA: To count cells that are not empty

    • COUNT: To count cells that contain numbers.

    • COUNTBLANK: To count cells that are blank.

    • COUNTIF: To count cells that meets a specified criteria.

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

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

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

  2. On the Formulas tab, click Insert, point to Statistical, and then click one of the following functions:

    • COUNTA: To count cells that are not empty

    • COUNT: To count cells that contain numbers.

    • COUNTBLANK: To count cells that are blank.

    • COUNTIF: To count cells that meets a specified criteria.

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

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

See Also

Count unique values among duplicates

Count how often a value occurs

COUNT function

COUNTA function

COUNTBLANK function

COUNTIF function

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×