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

IF is one of the most widely used logical functions in Excel. It tests a condition and evaluates to either TRUE or FALSE. An IF formula has two possible outputs, one when the condition is TRUE and ...