Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

See Also

Count unique values among duplicates

Count how often a value occurs

COUNT function

COUNTA function


COUNTIF function

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!