SUMIF formula works as a conditional sum. All values in the range that meet the condition or criteria are included in the sum. SUMIF is very useful for single criterion sum formulas.SUMIF formula works as a conditional sum. All values in the range that meet the condition or criteria are included in the sum. SUMIF is very useful for single criterion sum formulas.