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.