In this example, typing =SUM(INDIRECT(A2)) ... and we're also using the INDIRECT function to tell Excel where to look to calculate this average.

2. SUM functions. Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers—but it doesn’t just sum.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

For example, if you need to count rows where two overlapping conditions are met, ... Below are more guides on Excel’s SUM function from our extensive range of articles.