SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.