Articles → EXCEL FORMULA → Sumif Function In Excel

Sumif Function In Excel



=SUMIF(Range, criteria)

  1. Range – Range of cells that need to be sum up.
  2. Criteria – Condition which tells whether a particular cell in the range is included in the sum or not.


  1. If a person is earning less than or equal to 250000 then exclude it from the sum
  2. If a person is earning more than 250000 then include this income in the sum.

Picture showing the output of Sumif function in excel
Click to Enlarge

Posted By  -  Karan Gupta
Posted On  -  Tuesday, November 29, 2016


Your Email Id  
Query/FeedbackCharacters remaining 250