Applications

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

Formula

=SUMIF(range, expression)

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

=SUMIF(A1:A8,">4000")

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

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

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

=SUMIF(A1:A8,">1000")

Formula Parameters

  • Range – The first part of the formula lets you specify the range to add.
  • Expression – The second part of the formula lets you specify the condition. The condition is in string form. You can use multiple logical operators.
=SUMIF(A1:A8,">=1000")
=SUMIF(A1:A8,"<=1000")

Screen shot 2016 10 03 at 8.11.00 am