0

The formula starts by looking for multiple criteria one by one and then the resulting arrays are multiplied with each other. The final sum is done by using SUMPRODUCT().

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

The formula starts by looking for multiple criteria one by one and then the resulting arrays are multiplied with each other. The final sum is done by using SUMPRODUCT().