The function sum() adds values from multiple cells and returns a specific numeric value.
Step-by-step explanation:
The sum() function is used to add many values that are specified within the function. the values that are in need to be summed up must be given as an argument to this function. This function returns the specific value which is the summed up result. The specification =SUM(A2:A10) is used to sum up the values of the cells A2 to A10.
The argument of this function may be an array, range of cells, values etc. This function will ignore the cells that are empty and cells that has text values. If an error occurs in the argument then the result returned will also have error. The function Aggregate is used to ignore these errors.