0
The SUBTOTAL function allows you to do different kinds of calculations. You can specify a range to act on and then, by using a number between 1 and 11 or 101 and 111, you can specify which of the following 11 functions you want to use:
AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR, VARP
For example, SUM is number 9 and also 109. So to use the SUBTOTAL function to sum the range A2:A30, you could do either of these:
=SUBTOTAL( 9, A2:A30 )
=SUBTOTAL( 109, A2:A30 )
If you use 1 to 11 as the code it will include hidden values, while 101 to 111 will ignore hidden cells.
Wiki User
∙ 8y ago
Wiki User
∙ 13y agoMicrosoft Excel can automatically calculate subtotal and grand total values in a list. When you insert automatic subtotals, Excel outlines the list so that you can display and hide the detail rows for each subtotal.
To insert subtotals, you first sort your list so that the rows you want to subtotal are grouped together. You can then calculate subtotals for any column that contains numbers.
Function_num is the number 1 to 11 that specifies which function to use in calculating subtotals within a list
Function Num
Function
1AVERAGE
2COUNT
3COUNTA
4MAX
5MIN
6PRODUCT
7STDEV
8STDEVP
9SUM
10VAR
11VARP
Example:
The example may be easier to understand if you copy it to a blank worksheet.
A
1
Data
2
100
3
105
4
140
5
230
Formula
Description (Result) =SUBTOTAL(9,A2:A5)Subtotal of the column above using the SUM function (575) =SUBTOTAL(1,A2:A5)Subtotal of the column above using the AVERAGE function (143.75)
Wiki User
∙ 13y agoIt means all total sum of required number.
Add your answer:
Earn +20 pts
What is the name of the function in Excel that allows numbers to be quickly totalled?
The SUM function. You could also do it with the SUBTOTAL function, but the SUM function is the best one to use.
Where does the Subtotal command insert a row?
The SUBTOTAL function does not insert a row. It returns the result in the cell where you type the formula. See related links for information about the SUBTOTAL function.
When using the SUBTOTAL function which is the function number for the SUM function?
4
What Excel function is used to calculate a total?
There is no function called TOTAL in Excel. You can get totals using several functions, most commonly the SUM function. There is a function called SUBTOTAL which allows you to do different types of standard calculations, including getting totals, averages, highest numbers, lowest numbers and some other things.
How can Excel summarize data in a range of data?
It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.It can use functions like the SUM function or the SUBTOTAL function. Depending on what exactly the user wants to do, there are lots of functions that could be used to summarise the data.
What is subtotal percentage formula field?
Are you asking about something in Excel? Can you give example?
What is better to use in adding cells that are not aligned in any row or column?
There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.
Why total is not used when finding the totals instead sum is used in Excel?
Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.Sum is a mathematical term that is more commonly used than totals. A SUM function is found in all spreadsheet applications, not just Excel. There were other spreadsheet programs in existence before Excel and they used Sum, so Excel was following the standard. The SUM function is actually capable of doing lots of other things, as you can enclose any calculation in its brackets, though it is generally best to reserve SUM for summing a range of cells. There is also a function in Excel called SUBTOTAL which can do a range of calculations, combining some of the standard ones into a single function, such as summing, averaging, finding a maximum and minimum value etc.
Where can you enter a sum in excel?
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
What is the step function of Microsoft Excel?
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
A formula prewritten by excel is called?
Function
Does the uplookvert function in Excel exist?
There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.
