Скачать или смотреть Excel SUM Function.

Description of the Excel SUM Function
Excel is a powerful tool for data management, and one of its most fundamental and useful functions is SUM. The SUM function is used to add together a series of numbers, either individually or as part of a range of cells. It is one of the most commonly used functions in Excel because it allows users to quickly and easily calculate the total of a large number of values.

Basic Usage
The basic syntax for the SUM function is:

Here, number1, number2, ... represent the values to be added. These values can be specific numbers, cell references, or even ranges of cells. For example, if you want to add the values in cells A1, A2, and A3, you would use the formula =SUM(A1, A2, A3).

Using Cell Ranges
One of the most useful features of the SUM function is its ability to work with ranges of cells. Instead of typing each cell reference separately, you can specify a range of cells. For instance, if you want to sum the values in cells from A1 to A10, you can use =SUM(A1:A10). This saves time and reduces the risk of errors, especially when working with large amounts of data.

Combined Usages
The SUM function is also flexible enough to combine individual cell references and cell ranges within the same formula. For example, =SUM(A1, A3, B1:B5, 10) would add the values in cells A1 and A3, the sum of the cells in the range B1 to B5, and the number 10.

Error Handling
When using SUM, it's important to be aware that non-numeric values in cells are not included in the sum. This means that cells containing text or errors like #VALUE! are automatically ignored. If all arguments are non-numeric, SUM will return 0.

Summary
The SUM function is indispensable in Excel for anyone working with numerical data. It offers a quick and easy method for calculating the total of multiple values, whether these are individual numbers, cell references, or ranges. With its flexibility and simplicity, SUM is a fundamental function that every Excel user should master.