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.

The SUMIF function in Excel is used to add all the cell values and return the results on the basis of one criterion. ... Now read: 10 Text functions in Excel with examples.

For example, =Sum(B2: B5) adds values in cells B2 and B5. =Sum(B2:B5, C2:C5) adds the value in cells B2 and B5 as well as cells C2 and C5. READ : How to use Substitute and Replace Functions in ...

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.