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!
Merge Cells in Excel Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean…
REPT function is used to repeat the text or cell reference to multiple times
Watch: How to use EOMONTH & EDATE Function in Excel? What is EOMONTH Function? The EOMONTH function in Excel returns the last day of a month based on a given date and a specified number of…
Microsoft Excel is a useful tool for analyzing data and conducting statistical research. The program includes numerous functions for performing various statistical calculations. One of the essential measures Excel supports is the weighted average.
The tutorial explains what the Compound Annual Growth Rate (CAGR) is and shows how to create a clear and easy-to-understand formula for calculating CAGR in Excel.
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.