In this Article

*This tutorial will demonstrate how to use the SUMIFS Function to sum rows with data less than (or equal to) a specific value in Excel and Google Sheets.*

## Sum if Less Than 0

The SUMIFS Function sums data rows that meet certain criteria. Its syntax is:

This example will sum all **Scores** that are less than zero.

1 |
=SUMIFS(C3:C9,C3:C9,"<0") |

We include the criteria “<0” to sum all negative **Scores**. In this example, the criteria is also applied to the data in the **Score** column and so the cell range C3:C9 is used as both the sum range and the criteria range.

## Sum if Less Than

This example sums the **Revenue** for all **Order Numbers** less than 527.

1 |
=SUMIFS(C3:C9,B3:B9,"<527") |

To write the logical test for “less than 527” in the SUMIFS Function, use “<527”.

### Sum if Less Than or Equal to

To include **Revenue** from **Order Numbers** which are less than or equal to 527, we can modify the formula to be:

1 |
=SUMIFS(C3:C9,B3:B9,"<=527") |

### Sum if Less Than – Cell References

Usually, it is bad practice to hard-code values into formulas. Instead, it is more flexible to use a separate cell to define the criteria’s value.

1 |
=SUMIFS(C3:C9,B3:B9,"<"&E3) |

Now we add the logical operator within double quotes (“”) and use & to join the operator and the value:

“<“&E3

Other logical operators can be used in this formula, such as:

- Equal to (“=”&E3)
- Less than or equal to (example: “<=”&E3)
- Greater than (“>”&E3)
- Greater than or equal to ( “>=”&E3)
- Not equal to (“<>”&E3)

## Locking Cell References

To make our formulas easier to read, we’ve shown the formulas without locked cell references:

1 |
=SUMIFS(C3:C9,B3:B9,"<"&E3) |

But these formulas will not work properly when copy and pasted elsewhere in your file. Instead, you should use locked cell references like this:

1 |
=SUMIFS($C$3:$C$9,$B$3:$B$9,"<"&E3) |

Read our article on Locking Cell References to learn more.

## Sum if Less Than in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.