### SUM Functions and Formulas in MS-Excel in 6 Best Ways

**Sum Functions and Formulas in MS-Excel:** In an excel spreadsheet, you can add number values in many different ways by using the pre-defined functions, user-defined formulas, or any other options in the ribbon. These are summarized below.

## Sum Function in MS-Excel in Several Ways:

**Excel Function (Pre-defined):** An excel sum function adds the selected numbers in a cell or a range of cells. The value can be number, cell reference (address), range, or array. If you select any other character/s besides numbers for addition, the sum function ignores without errors by adding the numeric value.

## SUM Functions and Formulas in MS-Excel

**Syntax for Sum Function: **

=SUM(number, number2, number3…)

Or,

=SUM(**first cell reference : last cell reference**)

Example:

=SUM(A1:D1)

**Method-1**

=SUM(b2:b7)

In the above **SUM** function, b2:b7 is the range getting by selecting from the first cell reference b2 to the last cell reference b7.

**Method-2**

=SUM(b2:b7)

In the above SUM function, b2:b7 is the range. And each reference in a range is taken as given below.

**B2** → It is the first cell reference getting by typing or selecting b2

: → Shift + ;

**B7** → It is the last cell reference getting by clicking or typing b7

**Method-3**

**Sum Function in Excel Using Range**

=SUM(b2:b7)

In the above **SUM** function, b2:b7 is the range. And each reference in a range is taken as given below.

**b2** → It is the first cell reference getting by selecting or typing b2

**:b7** → press and hold down “**Shift + →** or **Shift + ↓**” (selecting the range till the last cell b7 is to be selected)

**Method-4**

**Sum Function **in Excel **using Range:**

=SUM(b2:b7)

In the above SUM function, **b2:b7** is the range. And each reference in a range is taken as given below.

**b2** → It is the first cell reference getting by selecting or typing b2

**:b7** → Keep hold down the “**Shift**” key, and then click the last cell (b7).

**Method-5**

**Auto Sum → **Alt + =

=SUM(b2:b7) function is taken as describing below.

**Auto Sum** **Function **in Excel**:**

· Select the range that you want to add the numbers, then press **Alt + =**.

(Or)

· Select the range of cells that you want to ad its number value.

· On the **Home** tab, in the **Editing** group, click the “**AutoSum**” command.

**Methode-6**

=sum(a3,b2:b7,d6)

**Reference, Range, and Reference: **In the above method, you can select the cell, range, then cell that contain numbers to ad as given below

· **a3 **→ select the cell that contain number.

· ** ****b2:b7 ** → Select the range of cells that contain numbers.

· **d6 ** → select the cell that contain number.

## Insert Sum Function in MS-Excel:

There are two ways to insert Sum function in excel, these are explained below.

- Type the number value that you want to add, then click below the last number of your number list.
- Click on the fx icon that appears right to the formula bar to open the insert function dialogue box.
- Type the “Sum” to search for a function in the functions text box.
- Then click on “Go”, and then select the “Sum” as it is a function.
- Now click on “OK” to open a insert function dialogue box.

## Sum Functions and Formulas in MS-Excel:

- Now select one-by-one number or select the range of cells that you want to add.
- Lastly, click OK.

## Sum Functions and Formulas in MS-Excel:

## Sum Formulas in MS-Excel:

**Excel Sum Formula (User-defined): **An excel sum formula adds the entered or selected numbers in a cell or a range of cells. The value can be number, cell reference (address). If you select or enter any other character besides numeric value, it shows an error.

**Formula-1**

**= 20+60+352+4+54+54**

1. Type an equal sign {=}

2. Start entering the number value then enter the plus sign {+} between the numbers.

**Formula-2**

= f5+b1+c3+d1+n3

1. Type an equal sign {=}

2. Start selecting the cells that contain number then enter the plus sign {+} between the cell references.

## Related Posts:

## Sum Functions and Formulas in MS-Excel in Several Ways

##### SUM Functions and Formulas in MS-Excel in 6 Best Ways

Sum Functions and Formulas in MS-Excel: In an excel spreadsheet, you can add number values in many different ways by using the pre-defined functions, user-defined formulas, or any other options in the ribbon. These are summarized below.

**Course Provider: ** Organization