### 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 SUMIF function to satisfy one condition.* You can use the SUMIFS function to satisfy multiple conditions.* You can use the AGGREGATE function to exclude hidden rows.* For the Microsoft documentation refer to support.office.com

 A B 1 =SUM(3,2) = 5 3 2 =SUM(B1,B2) = 5 2 3 =SUM(B1:B2) = 5 3 4 =SUM(B1,B2,B3) = 8 some text 5 =SUM(B1,B2,B3,B5) = 8 6 =SUM("3","2",B3) = 8 some 7 =SUM(B1:B5,"0") = 8 text 8 =SUM(B1:B3,15) = 23 9 =SUM(LEN(B1),LEN(B4)) = 10 10 =SUM(10,20,30) = 60 11 =SUM({10,20,30}) = 60 12 =SUM(1/COUNTIF(B1:B3,"<10")) = 0.33 13 =SUM(IF(B1:B3>=20,IF(B1:B3<=100,B1:B3,0),0)) = 0 14 =SUM(IF(B1:B3>=20,IF(B1:B3<=100,1,0),0)) = 0 15 {=SUM(LEN(B6:B7))} = 8 16 =SUM(LEN("some text")) = 9 17 {=SUM({1,2,3,4}^2)} = 30 18 {=SUM({1,2}*{3,4})} = 11 19 =SUM(1,2,"some text") = #VALUE! 20 =SUM(B1:B5,"") = #VALUE! 21 =SUM(LEN(B6:B7)) = #VALUE!

 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}.