Excel COUNT and COUNTA Formula

In this tutorial we will learn and apply 2 Formula

1. Count Formula – It counts the number of cells that contain numbers, and counts numbers within the list of arguments.
2. Counta Formula – It counts the number of cells that are not empty in a range

Full Excel Course in Hindi

  • Get 2-Year Access with unlimited views of 220+ videos
  • Get Course Completion Certificate & Excel Mastery eBooks

1. Count Formula

There is a table that consists of numbers colored in grey. Now I want to count the number of cells that contains numbers from the given table.

So to calculate the number of cells that contain numbers we will be applying Count Formula:

1. Write =count and press the Tab Key

2. Select all the grey colored cells from the table and close the bracket

3. Press Enter and you will get your answer

2. Counta Formula

Here, if I have a text or character in a given table and want to count the number of cells that are not empty in range then we will be applying Counta Formula:

1. Write =counta and press the Tab Key

2. Select all the grey colored cells from the table and close the bracket

3. Press Enter and you will get your answer