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.
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
SUMPRODUCT(array1, [array2], [array3], ...)
Returns TRUE if the value is text
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM