0
Sumproduct evaluates the array against the given criteria and based on if it matches or not, returns an array of 1s and 0s, that multiplies with the array to be summed to give the final answer.
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
SUMPRODUCT(array1, [array2], [array3], ...)
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
Sumproduct evaluates the array against the given criteria and based on if it matches or not, returns an array of 1s and 0s, that multiplies with the array to be summed to give the final answer.