SUM(number1 [,number2] [..]) 
Returns the total value of the numbers in a list, table or cell range. 
number1  The first number. 
number2  (Optional) The second number. 
Remarks 
* This function includes hidden rows. * Arguments that are logical values are excluded. * Arguments that are text are excluded. * If any cell references are empty, then these are excluded. * If any cell references contain an error, then that error is returned. * You can have a maximum of 255 arguments. * There is also an AutoSum button to help you enter this function quickly. * It is possible to add up all the values in a particular column. To sum all the values in column "C" use: "=SUM(C:C)". * You can use the SUMIFS function to satisfy multiple conditions. * You can use the SUMPRODUCT function to return the sum of the product of one or more arrays of values. * You can use the SUMVISIBLE  User Defined Function if you want to exclude hidden rows. * You can use the AGGREGATE function to exclude hidden rows. * This is similar to the AVERAGE function. * This is similar to the COUNT function. * For the Microsoft documentation refer to support.office.com 

1  What is the sum of 3+2. 2  What is the sum of the values in cells "B1" and "B2". 3  What is the sum of the values in the range "B1:B2". 4  What is the sum of the values in the cells "B1", "B2" and "B3". 5  What is the sum of the values in the cells "B1", "B2", "B3" and "B5". 6  What is the sum of the values "3", "2" and the value in cell "B3". The text string values are automatically converted to numbers. 7  What is the sum of the values in cells "B1:B5" and "0". The text in cell "B4" is ignored. 8  What is the sum of the values in cells "B1:B3" and the number 15. 9  What is the length of the value in cell "B1" added to the length of the value in cell "B4". 10  What is the sum of 10+20+30. 11  What is the sum of 10+20+30, this time the values are entered as an static array. 12  What is the sum of all the value returned by the formula. There is only 1 value to sum in this example. The COUNTIF function returns the number of cells in the range "B1:B3" that contain a value of less than 10. 15  Array Formula. 17  Array Formula. What is the sum of the squares of the numbers {1,2,3,4}. 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top