0

The formula validates if the lookup range has the same product as the one we want to sum, the corresponding sales figure in the column B is added 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

The formula validates if the lookup range has the same product as the one we want to sum, the corresponding sales figure in the column B is added to give the final answer.