SUM(number1 [,number2] [..])

Returns the total value of the numbers in a list, table or cell range.

number1The 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

 AB
1=SUM(3,2) = 53
2=SUM(B1,B2) = 52
3=SUM(B1:B2) = 53
4=SUM(B1,B2,B3) = 8some text
5=SUM(B1,B2,B3,B5) = 8 
6=SUM("3","2",B3) = 8some
7=SUM(B1:B5,"0") = 8text
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}.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top