As soon as you start typing a Subtotal formula in a cell or in the formula bar, Microsoft Excel will display a list of available function numbers for you.įor example, this is how you can make a Subtotal 9 formula to sum up the values in cells C2 to C8: In fact, there is no need to memorize all function numbers. Returns the standard deviation based on an entire population of numbers.Įstimates the variance of a population based on a sample of numbers.Įstimates the variance of a population based on an entire population of numbers. Returns the standard deviation of a population based on a sample of numbers.
The function_num argument can belong to one of the following sets: The first ref argument is required, others (up to 254) are optional. Ref1, Ref2, … - one or more cells or ranges to subtotal.Function_num - a number that specifies which function to use for the subtotal.The syntax of the Excel SUBTOTAL function is as follows: The SUBTOTAL function is available in all versions of Excel 2016, Excel 2013, Excel 2010, Excel 2007, and lower.
Unlike other Excel functions that are designed to do only one specific thing, SUBTOTAL is amazingly versatile - it can perform different arithmetic and logical operations such as counting cells, calculating average, finding the minimum or maximum value, and more. In this context, "subtotal" is not just totaling numbers in a defined range of cells. Microsoft defines Excel SUBTOTAL as the function that returns a subtotal in a list or database.
#How to subtotal data in excel and show only the result how to#
Today, you will learn how to write Subtotal formulas on your own and what advantages this gives to you.
In the previous article, we discussed an automatic way to insert subtotals in Excel by using the Subtotal feature. The tutorial explains the specificities of the SUBTOTAL function in Excel and shows how to use Subtotal formulas to summarize data in visible cells.
0 kommentar(er)
