offers Excel lesson videos made simple!

Sign up or log in to Magoosh Excel.

Understanding the Counta Function in Excel

In Microsoft Excel, especially when you’re working with a lot of data, counting cells manually would not be fun and can lead to human error as well. For this reason, Excel comes to the rescue with the Counta Function, saving you countless tedious hours! We will discuss the different methods of counting cells on the basis of conditional statements in this post.

Counting Number of Non-Empty Cells

This section explains in detail the procedure of counting non-empty cells and discusses how the commands can be implemented to calculate the number of non-empty cells.

The following steps need to be performed sequentially in order to count the number of non-empty cells in Excel:

  1. Click on the cell in Excel where you want the result to appear for the number of non-empty cells.
  2. Click on Formulas Tab on Menu Bar, click on More Functions option under Function Library section, and further click on Statistical option.
  3. Click on COUNTA function under the list of functions that appear.
  4. Select the range of cells on which the built-in formula needs to be applied under Function Arguments dialog box using the table button given alongside for selection.
  5. Click on OK button in the dialog box.

The result or count of the number of non-empty cells would be computed and displayed in the selected cell.

OR

  1. Click on the cell where you want the result to appear for the number of non-empty cells.
  2. Click on Formula Bar, available under Menu Bar and type the function following the aforementioned syntax:
    =COUNTA( Range_Of_Cells )
    where Range_Of_Cells is given by CellAddress1: CellAddress2.
  3. Press Enter Key on keyboard so that the result is computed.

The result or count of the number of non-empty cells would be computed and displayed on the selected cell.

Though the COUNTA function can be used to calculate the number of non-empty or non-void cells in Excel, a variety of other count functions can also be used in order to count the conditional or requisite cells in Excel, in order to further perform and facilitate other functions, based on the COUNT command.

Counting Number of Empty/Blank Cells

This section explains in detail the procedure of computing the number of empty or blank cells in Excel and discusses the application of the function to calculate the number of empty cells or basically cells, containing no values and are void can be calculated.

The following steps need to be performed sequentially in order to count the number of empty/blank cells in Excel:

  1. Click on the cell in Excel where you want the result to appear for the number of empty cells in Excel.
  2. Click on Formulas Tab on Menu Bar, click on More Functions option under Function Library section, and further click on Statistical option.
  3. Click on COUNTBLANK function in the list of function that appear.
  4. Select the range of cells on which the built in formula needs to be applied under Function Arguments dialog box using the Table button in order to highlight the requisite cells.
  5. Click on OK button in the Dialog Box.

The result or count of the number of empty or blank cells would be computed and displayed in the selected cell.

OR

  1. Click on the cell where you want the result to appear for the number of empty or blank cells.
  2. Click on Formula Bar, available under Menu Bar and type the function following the aforementioned syntax:
    =COUNTBLANK(Range_Of_Cells)
    where Range_Of_Cells is given by CellAddress1:CellAddress2
  3. Press Enter key on keyboard to compute the number of empty cells.

The result or count of the number of empty or blank cells would be computed and displayed in the selected cell.

Counting Number of Cells containing Numbers

This section discusses in detail the method of calculating the number of cells containing values which are numerical can be calculated.

The following steps need to be performed sequentially in order to count the number of cells containing numerical values in Excel:

  1. Click on the cell in Excel where you want the result to appear.
  2. Click on Formulas Tab on Menu Bar, click on More Functions option under Function Library section, and further click on Statistical.
  3. Click on COUNT function.
  4. Select the range of cells on which the built-in formula needs to be applied under Function Arguments dialog box.
  5. Click on OK.

The result or count of the number of cells containing numerical values will be computed.

OR

  1. Click on the cell where you want the result to appear.
  2. Click on Formula Bar, available under Menu Bar and type the function following the syntax:
    =COUNT(Range_Of_Cells)
    where Range_Of_Cells is given by CellAddress1:CellAddress2.
  3. Press Enter key on keyboard.

The result or count of the number of cells containing numerical values will be computed.

Counting Number of Cells containing Text

This section discusses how the number of cells containing values which are textual can be calculated. The approach follows subtracting the number of cells containing the textual value from the number of cells containing any value, that is, cells being non-void or empty. This is based on the premise that the cell is containing either textual or numerical values only.

The following steps need to be performed sequentially in order to count the number of cells containing textual values in Excel:

  1. Click on the cell in Excel where you want the result to appear.
  2. Click on Formula Bar, available under Menu Bar and type the function following the syntax:
    =COUNTA(Range_Of_Cells)-COUNT(Range _Of_Cells)
    where Range_Of_Cells is given by CellAddress1:CellAddress2.
  3. Press Enter Key on Keyboard.

The result or count of the number of cells containing textual values will be computed.

OR

The result or count of cells containing textual values can be calculated by separately calculating the result or count of cells containing numerical and non-empty/non-void values, and subtracting the former from the latter, provided that the cells contain either textual or numerical values only.

Comments are closed.


Magoosh blog comment policy: To create the best experience for our readers, we will only approve comments that are relevant to the article, general enough to be helpful to other students, concise, and well-written! 😄 Due to the high volume of comments across all of our blogs, we cannot promise that all comments will receive responses from our instructors.

We highly encourage students to help each other out and respond to other students' comments if you can!

If you are a Premium Magoosh student and would like more personalized service from our instructors, you can use the Help tab on the Magoosh dashboard. Thanks!