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

0

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.

0

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.