Microsoft Office Tutorials and References
In Depth Information
Summing Things Up
Table 8-3 (continued)
Function Number
for First Argument
Function
Description
6
PRODUCT
Returns the product of a group of numbers
7
STDEV.S
Returns the standard deviation from a
sample of values
8
STDEV.P
Returns the standard deviation from an
entire population, including text and logical
values
9
SUM
Returns the sum of a group of numbers
10
VAR.S
Returns variance based on a sample
11
VAR.P
Returns variance based on an entire
population
Figure 8 -4 exemplifies a few uses of the SUBTOTAL function. Raw data values
are listed in Column A. The results of using the function in a few variations
are listed in Column C. Column E displays the actual function entries that
returned the respective results in Column C.
Figure 8-4:
Working
with the
SUBTOTAL
function.
Using named ranges with the SUBTOTAL function is useful. For example,
=SUBTOTAL(1, October_Sales, November_Sales, December_sales)
makes for an easy way to calculate the average sale of the fourth quarter.
Search JabSto ::

Custom Search