Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...(...B4:B11=C13)*(...C4:C11))

How to use SUMPRODUCT() to sum against a criteria.

The SUMPRODUCT formula works by chedking the data_array for a value and then summing the data against it thus it can be used to validate against a criteria and the summing respective values. The formula works by comparing the criteria with the range of values and then return a binary array. This is multiplied with the data range to return only values with one againt them and the result is summed.


Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

Syntax

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

Lets chat on this