To count the values of text, numeric and blank cells in a range use the below formula.
Count ()-Counts the numeric values.
CountA ()-Counts the non-empty cells.
And COUNTA (A2:A15)-COUNT (A2:A15) returns the character values.
Hope this helped.
Count Number Of Blank Values/Character Values/Numeric Values In Excel
Random Posts
- Top 100 Excel Interview Question And Answers For Data Analyst
Question-What are some differences between Google sheets and Excel. Google sheet is not paid, excel is paid Easy collection & […]
Extract/Get String After First Space/Blank In ExcelIn this post we will see how we could extract the string after first space in excel. We have value […]
Convert Text URL Column Into Hyperlinks In ExcelIn this post we will see how could we convert a number of text url’s in a column to hyperlink […]
