Shulou(Shulou.com)06/03 Report--

What is the function sum? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

The function sum means to return the sum of the text expressions of numbers, logical values, and numbers in a range of cells. If there is an error value in the parameter or it is text that cannot be converted into a number, it will cause an error.

The function sum means:

The SUM function refers to the sum of text expressions that return numbers, logical values, and numbers in a range of cells. If there is an incorrect value in the parameter or is text that cannot be converted to a number, it will result in an error.

The SUM function is a mathematical and trigonometric function that adds values. You can add a single value, cell reference, or range, or a combination of the three.

(1) Grammar: SUM (number1, [number2],...)

Number1 (required parameter) the first number to add. The number can be a number, or a cell reference such as A1 in Excel, or a range of cells such as A2:A8.

Number2, this is the second number to be added.

(2) description

1. Text expressions for logical values and numbers will be evaluated

2. If the parameter is an array or reference, only the numbers in it will be calculated. Blank cells, logical values, and text in arrays or references will be ignored

3. If there is an error value in the parameter or text that cannot be converted into a number, it will result in an error.

The answer to the question about what is a function sum is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.