To use a total formula in excel, one must know the excel interface and basic knowledge of a cell, cell reference, row, column, range, mathematical operators, and the difference b/w formulas and functions. To return the total in excel, we have many formulas and functions.

## Table of Contents

## Total Formulas and Functions in Excel:

To add numbers in a range in excel, you can use subtotal total formulas or functions. To do so, get started now.

**Manual Method 1:**

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

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

1. Type an equal sign {=}

2. Start entering the number value, followed by the plus sign {+} (between the cell numbers).

3. Then press **Enter** to return the value.

**Method 2**;

= f5+b1+c3+d1+n3

1. Type an equal sign {=}

2. Start selecting the cells that contain numbers, followed by the plus sign {+} (between the cell references).

3. Then press **Enter**.

**Manual & Automatic:**

**Subtotal:** Returns subtotal using a provided list of functions in a database.

**Syntax: **=subtotal(function number, reference1, …)

**Steps:** To use the subtotal function, do the following.

- Type
**=subtotal(**

- Select the function number that you want to return the related function’s subtotal
- Select the cell range and press
**)** - Lastly, press
**Enter.**

**Sum**: It is used to add numbers from the selected cells you want.

**Syntax**: =sum(number1, [number2], …)

(or)

=sum(cell reference 1, cell reference 2, cell reference3, …)

(or)

=sum(first cell reference: last cell reference)

**Steps**: type **=sum(** and click on the **cell reference **that contains **numbers **where you want to start adding numbers, then type**:** and then click the last cell that contains numbers to form a range and close the bracket **)**, lastly press **enter**.

Example: **=sum(b3:h6)**.

**Method 1 to calculate total function in excel:**

**=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 holding down the “Shift” key and then click the last cell (b7).

**Method-5**

**Auto Sum → **Alt + =

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

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

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

(Or)

· Select the range of cells to that you want to add 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 contains numbers to ad as given below

· **a3 **→ select the cell that contains a number.

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

· **d6 ** → select the cell that contains a number.

#### Method-7

You can also use the sum function as a total formula in excel as given below. (Don’t use these too much time taking sum / total formula in excel).

- =sum(20+30+60+855+545+45)
- =sum(a2+g3+d5+f6).

**Autosum**: The function that automatically selects the list of the numbers in a row or the numbers in the columns and returns the total is called Autosum.

### Two ways to insert the Sum/ Total function in excel.

- Type the number value that you want to add, then click below the last number on your number list.

- Click on the fx icon that appears right in 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 “Sum” as it is a function.
- Now click on “OK” to open an insert function dialogue box.

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

### What is Required to Use sum Formula in Excel?

To use the sum formula in excel, one must know the excel interface and basic knowledge of a cell, cell reference, row, column, range, mathematical operators, and the difference b/w formulas and functions.