## Excel: SUM If Less Than

Formula to compute for values if cells have values less than a specified amount

### Formula

`=SUMIF(range, expression)`

Add the values in cells if the value is greater than 3000

`=SUMIF(A1:A8,"<3000")`

Add the values in cells if the value is greater than 1000

`=SUMIF(A1:A8,"<1000")`

Add the values in cells if the value is greater than 500

`=SUMIF(A1:A8,"<500")`

#### Formula Parameters

*Range*– The first part of the formula lets you specify the range to add. This is specified like this,`A1:A20`

*Expression*– The second part of the formula lets you specify the condition. The condition is in string form. You can use multiple logical operators like`<`

,`=`

,`<=`

,`>=`

`=SUMIF(A1:A8,"<=2000")`

`=SUMIF(A1:A8,">=2000")`

`=SUMIF(A1:A8,"=2000")`