The formula is SUMIFS (sum_range, criteria_range1, criteria1 [criteria_range2, criteria2,..]. How to use the Excel SUMIF function In this table, we want to calculate the number of mangoes sold.

All formulas in Excel begin with an equal sign, so the first symbol there is introducing the formula, not specifying anything about equality. To see if it's less than or equal to five, you'd use ...

Fortunately, the SUMIF () function can handle both. Summing only the negative values in a range of values sounds like a difficult task, but there’s a simple solution-use SUMIF ().