Microsoft Excel: Sum Function Example

Hi everyone, welcome back. Excel functions are predefined formulas that can be used to easily and quickly make calculations which can be used for statistical or analytical purposes. In this example, we will be going over the SUM function. The SUM function is used to add all the given values together. With this introduction out of the way, let’s get into it.

SUM Function on Two Individual Values

Let’s find out how we can use the SUM function on two individual values. Let’s see an example:

In our spreadsheet, we have a numeric value in cell A1 and a numeric value in cell A2. In cell A3, we have our SUM function which is prepared to calculate the sum of the value in A1 and the value in A2. Let’s press enter an check the result:

SUM Function on a Range of Values

Now, let’s see how we can use the SUM function on a range of values. Let’s see an example:

In our spreadsheet, we have a range of random values from cells A1 to A43. In cell A44, we have our SUM function which is prepared to calculate the sum of all the values from A1 to A43. Let’s press enter and check the result:

SUM Function on Multiple Ranges of Values

Now, let’s see how we can use the SUM function on more than one range of values. Let’s see an example:

In our spreadsheet, we have two ranges of random values from cells A1 to A43 and B1 to B43. In cell B44, we have our SUM function which is prepared to calculate the sum of all the values from A1 to A43 and from B1 to B43. Let’s press enter and check the result:

Conclusion

That is it for the SUM function examples in Microsoft Excel. Its main purpose is to add together all the given values. I hope this helps. If there are any questions or comments, please let me know. Thanks for reading.