Applications

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")

Screen shot 2016 10 03 at 8.17.06 am