The Sumproduct function can validate multiple criteria and the final count is measured and summed up by the function to give the answer.
Validating multiple criteria with SUMPRODUCT function
Using Sumproduct function for multiple criteria sum
How to use SUMPRODUCT function to validate a criteria and sum
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
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