Skip to content

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).

Sum or Total Formula in Excel
Sum or Total Formula in Excel

3. Then press Enter to return the value.

Returned total value
Returned total 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).

Manually Sum the Value
Manually Sum the Value

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(

Subtotal Function in Excel
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.

Sum or total Function in Excel
Sum Function in Excel

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.

Insert sum or total function in excel
Insert sum or total function in excel

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.

Enter values
Enter values

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.

Share