To use a total formula in excel, one must know the excel interface and basic knowledge over 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 Formula and Function in Excel:
To add numbers in a range in excel, you can use total or subtotal total formulas or functions. To do so, start with the total formula in excel.
Total Formula in Excel [Manual Method-1]:
An excel total 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 numeric value, it shows an error.
Do the following to manually use the total formula in excel.
Sum/Total Formula in Excel – 1:
= 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 total value.
Sum/Total Formula in Excel – 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.
Total Functions in Excel [Manual & Automatic]:
To use total or subtotal functions, do the following.
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 ) that you want to return subtotal
- 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 hold 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, 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 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/ total 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 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 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 an insert function dialogue box.
- Now select one-by-one number or select the range of cells that you want to add.
- Lastly, click OK.
Related Posts:
- Create a Photo Album in PowerPoint
- How to Use Hyphenation in MS Word
- The Draw Tab in Word, Excel, and Ppt
- Ways to Change Page Color in Word
- Word Counter | Character Counter – All Tools.
What is Required to Use Total Formula in Excel?
To use a total formula in excel, one must know the excel interface and basic knowledge over 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.