COUNTA
TheCOUNTA
function counts the number of nonempty cells within a specified range. It can take up to 30 arguments which can be individual cells or ranges. This function is commonly used to count the number of entries in a list or to determine the number of cells that contain data.
 How to use
COUNTA
formula?  Examples of using
COUNTA
formula COUNTA
formula not working? Similar formulas to
COUNTA
Usage
Use the COUNTA
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value1 (required):
The first value or range of cells to count.  value2, ... (optional):
Additional values or ranges of cells to count, up to a maximum of 30.
Examples
Here are a few example use cases that explain how to use theCOUNTA
formula in Google Sheets.
Counting entries in a list
To count the number of entries in a list, you can use the COUNTA
function to count the number of nonempty cells in a column or row of data.
Checking for missing data
The COUNTA
function can be used to check for missing data in a range of cells. If the count returned by the function is less than the number of cells in the range, then there is missing data.
Counting cells containing specific data types
The COUNTA
function can be used to count the number of cells that contain specific data types, such as text or numbers.
Common Mistakes
COUNTA
not working? Here are some common mistakes people make when using the COUNTA
Google Sheets Formula:
Miscounting empty cells
One common mistake is to forget that COUNTA counts empty cells as well. To avoid this, make sure to only include the range of cells that you actually want to count.
Counting nonnumeric values
Another mistake is to include nonnumeric values in your COUNTA formula. This can lead to inaccurate counts. To avoid this, make sure to only include cells that contain the type of value you want to count (e.g. numbers, text, etc.).
Not using parentheses
Sometimes users forget to enclose the values they want to count in parentheses. This can cause errors in the formula. To avoid this, always use parentheses when specifying the values you want to count.
Using the wrong range
Another mistake is to specify the wrong range of cells in the formula. This can cause the formula to return inaccurate counts. To avoid this, doublecheck that you have selected the correct range of cells before entering the formula.
Forgetting to include values
Finally, users sometimes forget to include all of the values they want to count in the formula. This can lead to inaccurate counts. To avoid this, make sure to include all of the values you want to count in the formula.
Related Formulas
The following functions are similar to COUNTA
or are often used with it in a formula:

COUNT
The
COUNT
formula returns the number of numeric values within a specified range of cells. It is commonly used to count the number of entries in a given range that meet specific criteria, such as counting the number of sales above a certain threshold. 
COUNTIF
The
COUNTIF
formula counts the number of cells within a specified range that meet a certain criterion. This formula is commonly used to count cells that meet a specific condition or criteria. 
SUM
The
SUM
function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

MAX
The
MAX
function returns the maximum value from a range of cells or a set of supplied values. It is commonly used to find the largest value in a dataset.
Learn More
You can learn more about the COUNTA
Google Sheets function on Google Support.