COUNTA Function in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> COUNTA Function in Excel



In this tutorial, you will learn about how to use excel COUNTA function. COUNTA function in excel is often used to count filled cells in your spreadsheet.


Why We Need to Learn About How to Use Excel COUNTA Function?


While processing data in this spreadsheet software, often we want to know how many cells are filled. This is needed to understand if our data is already complete or we need to find and add more so the processing result can be more credible. Usually we need this process when we get data from online database or from other sources that we do not know about the completeness of the data collection. Knowing how many filled cells is also needed if we want to know the amount of data number as one of the factor for next phase data processing.

To help in checking the amount of filled cells, there is COUNTA function in excel that we can use for the process. This excel COUNTA function is a variant from COUNT formula, from which there are other variants such as COUNTIF, COUNTIFS, and COUNTBLANK. Excel COUNTA function is often used because it can count the amount of all data that we have in a range.


What is COUNTA Function in Excel?


COUNTA function in excel is a formula with the usage objective to count the amount of filled cells in a range. This formula is pretty easy to use because it only needs one input, which is the range where we want to count the amount of data in it.

A little explanation about the inputs in the formula is as follows:


=COUNTA(value1, value2, …)


Note:
value1, value2, … = cell coordinate or data to count the amount of data from


How to Use Excel COUNTA Function?


The following will explain about how to use COUNTA function in excel in this spreadsheet tool. If you have used to practice other formula variants to calculate the amount of data such as COUNT and COUNTBLANK, then the learning of using this formula should be easy enough because the writing of this is almost the same as those formulas.


Using COUNTA Function in Excel

  1. Type equal sign ( = ) in the cell where you want to put the result in

    COUNTA Function in Excel - Screenshot of Step 1

  2. Type COUNTA (can be with large and small letters) and open bracket sign after =

    COUNTA Function in Excel - Screenshot of Step 2

  3. Drag cursor from the most top left to the most bottom right on the cells where you want to calculate the amount of filled cells are. You can also type comma sign ( , ) and add cell range in another place until all of them are in the formula

    COUNTA Function in Excel - Screenshot of Step 3

  4. Type close bracket sign after all cells that you want to be processed have already been inputted

    COUNTA Function in Excel - Screenshot of Step 4

  5. Press Enter
  6. The process is done!

    COUNTA Function in Excel - Screenshot of Step 6



Exercise


After you have learned the steps from above tutorial, you can practice your understanding through this exercise!

Download file from the link and answer the questions below. Please download the answer file to check if you have done practicing and sure about the results!

Link to download file for practicing your understanding:
Download here

Questions

  1. How many DUMMY in column J?
  2. How many DUMMY in the tenth row?
  3. How many DUMMY in all columns and rows?

Link to download answer file:
Download here


Additional Notes

  • In using COUNTA function in excel, drag cell cursor and numbers or cell coordinates input with comma sign separation can be done in one writing
  • If you want, cell coordinates which are near to each other for excel COUNTA function can also be written manually separated for the most top left cell and most bottom right cell by two dots sign ( : ) (Writing example: B1:D25)
  • If you want to calculate the amount of data with other needs beside what this formula can give, you can learn other excel formulas for that needs in the other part of this Compute Expert tutorial blog!




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert