Please enable JavaScript to view the comments powered by Disqus.


Countif a cell contains text

We will use SUMPRODUCT() function from MS Excel to calculate the count. The function will check the cell on the basis of another function ISTEXT() to check if it contains text. This will return an array of 0s and 1s that will be feed and summed up. 

Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components


SUMPRODUCT(array1, [array2], [array3], ...)

Category: Information

Returns TRUE if the value is text



Lets chat on this