Mathematical functions
Mathematical functions provide some of Excel's most basic functionality, allowing you to perform various operations like sums and averages.
- Excel's SUM function. The SUM function in Excel is one of the program's most basic features, allowing you to add up the values of numbers or cells.
- Cumulative SUM in Excel. It is possible to perform a cumulative SUM in Excel! In this tutorial, we combine SUM with absolute and relative cell references to get cumulative values.
- Using SUMPRODUCT in Formulas. SUMPRODUCT allows you to multiply multiple sets of numbers together and add the results. It is a core piece of a number of more advanced Excel formulas.
- Using the AVERAGE formula in Excel. The AVERAGE formula in Excel allows you to take the average of a series of numbers quickly and easily.
- Finding a Weighted Average in Excel. Wondering how to calculate a weighted average in Excel? We'll explain weighted averages, then show you how to calculate one using the SUMPRODUCT function.
- Finding a rolling average in Excel. A rolling average — also known as a moving average — helps you smooth out choppy trends and cyclicality when analyzing data.
- Using Excel's MAX Formula. The MAX function can be used in a formula to find the highest value within a given set or range.
- Minimum Values in Excel Using MIN. Minimum values within a set or range are easy to find using Excel's MIN function. We show you how!
- Using Excel's LARGE Function. Use LARGE to find the second largest, third largest, and kth largest values in an array. Learn how here!
- How To Use Excel's COUNT Function. The COUNT function is an important tool used to count the number of numerical values in an array. Learn how to use it here!
- Using Excel's COUNTA Function. COUNTA allows you to count the number of non-blank cells in a range. This useful function will help make your spreadsheets more dynamic. Learn more here!
- Using Excel's RANK function. RANK allows you to find the rank of a value within a given range. Inside we'll explain how to use the function, including how to break ties!