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.