The COUNTA is a cell counting function, which counts all cells in a range that has values, both numbers and letters.
=COUNTA(value1,[value2],...)
The COUNTA function is used when we need to count Non-Blank cells in a selected range.
For example, for counting cells from A1-A10, the formula is “=COUNTA (A1:A10).”
The function also counts the number of value arguments provided. The value argument is a parameter that is neither a cell nor a range of cells.
Formula =COUNT(B1:C10)
The COUNT Function will count the number of cells with numeric values within the selected range B1 to C10.
FORMULA =COUNTA(B1:E10
The COUNTA Function will count the number of cells with numeric values and Alpha numeric values within the selected range B1 to E10
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
FIND function is used to find the position of text, or character in an available string.
Discover free videos and tutorials to master Excel formulas and functions. Practice directly in our Online Excel Practice Files without downloading anything. Have questions? Drop them in the comments. Let’s begin! Basic Excel Formulas and…
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
FIND function is used to find the position of text, or character in an available string.
Discover free videos and tutorials to master Excel formulas and functions. Practice directly in our Online Excel Practice Files without downloading anything. Have questions? Drop them in the comments. Let’s begin! Basic Excel Formulas and…
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
FIND function is used to find the position of text, or character in an available string.
Discover free videos and tutorials to master Excel formulas and functions. Practice directly in our Online Excel Practice Files without downloading anything. Have questions? Drop them in the comments. Let’s begin! Basic Excel Formulas and…
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits