Excel SUM function to sum numbers in a range: #1 Easy method

Excel SUM Function to sum numbers in a range

You can use excel SUM function to sum numbers in a range. SUM function adds values. The basic formula to use the SUM function is:

=SUM (argument1, argument2, argument3…Argument_n)

Properties of arguments:

1. Argument can be a range, a number, or cell references
2. Each argument must be separated by COMMA (,)
3. Excel SUM function can handle up to 255 individual arguments

You can sum numbers in a range in two ways:

Method 1: By selecting the entire cell ranges in one formula:

We want to sum all the numbers of Apple, Orange, and Banana. We can simply select the range from A2 to C6 by using the following formula:

=SUM (A2:C6)

Method 2: By using separate cell ranges. In this example, we should use 3 cell ranges, and they are:

Apple = A2:A6

Orange =B2:B6

Banana=C2:C6

And the formula would be

=SUM (A2:A6, B2:B6, C2:C6)

Add numbers in excel:

To add 2 or more numbers in excel, you can simply use the following formula:

=SUM (10,5), and the answer would be 15

Let’s practice:

Formula	Description	Results
=SUM (10,5)	Adds 10 and 5	15
=SUM (“4”, 10, FALSE, TRUE)	Adds 4, 10, 1, and 1. Logical value “FALSE” and “TRUE” are translated into number 1. Excel has translated only the first logical value, FALSE.	15
=SUM (B2, B5)	Adds -4 and 0.4	-3.6
=SUM (B3, B4, B5)	Adds 10, 20, and 0.4	30.4
=SUM (B2:B5)	Adds values in cells B2 through B5	26.4
=SUM (B3:B4,10)	Adds values in cells B3 through B4, and then adds 10.	40
=SUM (21/3,24/3)	Adds values 21/3 and 24/3	15