Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...(...B4:B15=B17)*(...C4:C15>B18)*C4:C15)

How to sum given an array of values.

The formula starts by looking for multiple criteria one by one and then the resulting arrays are multiplied with each other. The final sum is done by using SUMPRODUCT().


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