=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!
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
RAND AND RANDBETWEEN FUNCTION We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users who creates random database for various types of working…
WORKDAY Function in Excel Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most commonly used function in Excel…
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
Excel Function DATE While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that…