Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...ISTEXT(...B4:B13)*1)

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

Syntax

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

Category: Information

Returns TRUE if the value is text

Syntax

ISTEXT(value)

Lets chat on this