SUMPRODUCT(...)
Countif a cell contains text
Used Functions
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
Practice SUMPRODUCT Formula at Sheetzoom
SUMPRODUCT formula at Microsoft helpCategory: Information
Returns TRUE if the value is text
Syntax
ISTEXT(value)
0
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.