The formula verifies if the cell contains text, if yes then it multiplies the binary array with the corresponding cell value and then calculates the sum with SUMPRODUCT.
How to count if cell contains text
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