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.
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
SUMPRODUCT(array1, [array2], [array3], ...)
Category: Information
Returns TRUE if the value is text
ISTEXT(value)
Create a new account
I already have an account
By signing in/up, you agree to the Terms of Use and Privacy Policy.
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
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.