Functions perform a mathematical calculation on a range of cells in Excel. The most common Functions are SUM, AVERAGE, COUNT, MIN, and MAX.

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.

The AGGREGATE function combines different numerical aggregation functions into one. It performs calculations such as SUM, COUNT, MAX, and MIN while ignoring errors, hidden cells, and even other ...