Sum if less than

To sum values if less than, use either the SUMIF function or SUMIFS function. In our example, first, we will use the SUMIF function to sum if less than.

In the cell E4, the formula is:

=SUMIF(B4:B8,”<30″) where,

B4:B8 is range of cells to add, against the criteria to be set later,

“>30” is the criteria to sum if less than 30.

Result:

Alternative with the SUMIFS functions

Formula:

Result:

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved