Please enable JavaScript to view the comments powered by Disqus.


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

Using SUMPRODUCT() function to sum ranges.

The formula is an array formula and 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