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.

For example, you might have sales data for each of your four main departments on four separate sheets. ... Excel's Sum function supports multiple sheet and cell references. Getty.

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.