Please enable JavaScript to view the comments powered by Disqus.


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

How to count if cell contains text

We will use the formula SUMPRODUCT() and ISTEXT() to first check if cells contain text and then sum the corresponding binary array returned using SUMPRODUCT() function. 


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