Please enable JavaScript to view the comments powered by Disqus.


SUMIF(...(...B4:B15),(..."<"&B17),(...B4:B15))

Calculate sum for the a given criteria with SUMIF for values less then criteria. 

The formula matches the given criteria with the lookup range values and return only those that are less then the given criteria, the final sum is obtained by summing up these values. 


Used Functions

Category: Math and trigonometry

Adds the cells specified by a given criteria

Syntax

SUMIF(range, criteria, [sum_range])

Lets chat on this