Microsoft Office Tutorials and References
In Depth Information
The DVARP function
returns the true
variance of an entire
GETPIVOTDATA returns a value of data stored in a PivotTable.
■ The pivot_table argument refers to the pivot table that contains the data you want to
retrieve. This can be a reference to any cell within the pivot table or a named range that
refers to the pivot table.
■ The name is the text string enclosed in double quotes or referenced as your lookup criteria.
The GETPIVOTDATA function can extract total sums from a pivot table or pull multiple sets of
data and find the information at their intersecting points. For example, notice the pivot table
in Figure 3.10. The months are shown down the left side and the years across the top. The
formula to look up a grand total for the year 2000 is simply
=GETPIVOTDATA(E4,”Sum of 2000”)
In this formula, E4 selects the entire PivotTable, and “Sum of 2000” in quotations is the
column heading. To look up information at intersecting points, such as the sum of August for
the year 2000, this is not case sensitive. The formula would read
OK=GETPIVOTDATA(E4,”Aug Sum of Sales”)