How to Use Total Formula in Excel – 2022

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.

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.