Please enable JavaScript to view the comments powered by Disqus.


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


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

Lets chat on this