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!
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.
This quick tutorial explains the basics of external references in Excel and shows how to reference another sheet or workbook in your formulas.
Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.
In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
Do you work with lots of data in Excel? Sorting, summarizing, and organizing information can take time. You may have used features like outlines, subtotals, or pivot tables before. But now, there’s an even simpler…