Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools


Adding amounts greater than zero


Adding amounts greater than zero or another given value in Excel is sometimes required and can be acquired by using the SUMIF or SUMIFS formulas.

The formula for adding amounts greater than a given value

=SUMIFS(sum range, sum range, “>0”)Adding_amounts_greater_than_zero

You can replace 0 with the value you need.

The condition inside the formula can also be modified if you need another type of condition.

The picture shows exactly how the function must be written and used in order to permit the operation to be done. The condition in the picture being 50 as an example for this Excel formula SUMIFS tutorial.

  • Facebook
  • Twitter
  • Google+
  • Linkedin
  • Pinterest

Leave a Comment

Your email address will not be published. Required fields are marked *

This div height required for enabling the sticky sidebar