Articles → EXCEL FORMULA → Sumif Function In Excel
Sumif Function In Excel
- Range – Range of cells that need to be sum up.
- Criteria – Condition which tells whether a particular cell in the range is included in the sum or not.
- If a person is earning less than or equal to 250000 then exclude it from the sum
- If a person is earning more than 250000 then include this income in the sum.
Click to Enlarge