After reading this article you will be able to count formula for Text only, even though cell range contain text and numbers (both) in a Data set. The return numbers are only a count of Texts it ignores any number, date or any numerical data sets.
We have two columns, Student Name and Marks. Our task is to know how many students Absent in column C.
Formula to implement:
Download Your Example Excel File
Formula Explanation (step by step)
You can also evaluate the formula, just click F9 function key in Excel.
Let’s break the formula into multiple small steps to understand its application.
Syntax: COUNTA(value1, [value2], …)
It counts all the values including text in the given range (C3 to C11)
Syntax: COUNT(value1, [value2], …)
Function returns count of cells that contain numbers (6) in the given range (C3 to C11)
(9-6) = 3
As text “Absent” comes three times in the given data range. so, it returns 3.