HOME
> Office programs
> Excel: Calculate Sum - How To Let Excel Calculate For You

# Excel: Calculate sum - how to let Excel calculate for you

In Microsoft Excel you have the possibility to let calculations within your tables be done automatically. All you need is the appropriate formula or function. Learn how to add values using the sum function and what you need to keep in mind.

### How to use the sum function in Excel

If you want to add several values to a sum in Excel, it works completely automatically if you use the sum function.### The syntax of the formula looks like this: "=SUM(number1;[number2];...)"

- The argument "number1" is required for the function to work. A value such as 2, a cell reference such as C4, or a cell range such as A4: A9 can be used.
- All subsequent values are optional and can be added with the specifications of argument Number1. Using the sum function, Excel is able to add up to 255 numbers together and give you a result.