Articles → EXCEL FORMULA → Sumif Function In Excel

Sumif Function In Excel






Purpose





Syntax


=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.

Example




  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

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250