dragonla.blogg.se - Openoffice base total formula

We wish to find out the total sales for the first six months. To understand the uses of the SUM function, let’s consider a few examples: Example 1 Arguments can be supplied as numbers, cell references, ranges, arrays, constants, and the results of other formulas or functions. The function sums values supplied as arguments (up to 255 arguments).

Number3 (optional argument) – This is the third item that we wish to sum.

Number2 (required argument) – The second item that we wish to sum.

Number1 (required argument) – This is the first item that we wish to sum.

The SUM function uses the following arguments: We can use the function to find out the total cost of the event. For example, we are given the cost of 100 items bought for an event. SUM helps users perform a quick summation of specified cells in MS Excel. It is the most popular and widely used function in Excel. The function will sum up cells that are supplied as multiple arguments. The SUM Function is categorized under Excel Math and Trigonometry functions.