The SUM function is probably the most basic function you need in Excel. Walter Hickey BI You type in =SUM( and then select an array of values.

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