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