Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...(...Data!$A$2:$A$4982=Sheet2!$B$4982)*(...Data!$B$2:$B$4982=Sheet2!C$2)*(...Data!$C$2:$C$4982=Sheet2!C$3)*(...Data!$E$2:$E$4982=Sheet2!$B4)*(...Data!$G$2:$G$4982))

Using Sumproduct function for multiple criteria sum

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.


Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

Syntax

SUMPRODUCT(array1, [array2], [array3], ...)

Practice SUMPRODUCT Formula at Sheetzoom SUMPRODUCT formula at Microsoft help

Lets chat on this


© 2017 Sheetzoom       Legal Stuff         Made with    in Istanbul

   START LEARNING EXCEL with SHEETZOOM