The SUMIF function can even sum numbers based on a date — such as values related to a specific date, or before or after a date. Suppose we want to total all the sales that happened on January 15.

This is the simplest example of the SUMIF function. Let's take it up a notch. Sum numbers that match specified criteria In the previous example, we evaluated the range of numbers from which we ...

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.