totn Excel

MS Excel 2003: GetPivotData Example #2

This Excel tutorial explains how to use the GetPivotData function (example #2) in Excel 2003 and older versions (with screenshots and step-by-step instructions).

In Microsoft Excel 2003/XP/2000/97, the GetPivotData function returns data from a pivot table. Let's look at an example that uses a named range.

Syntax

The syntax for the GetPivotData function is:

GetPivotData( pivot_table, name )

Parameters or Arguments

pivot_table
It is generally a named range that has been set up to point to the pivot table.
name
The name of the summary value that you wish to retrieve.

Example

Let's look at an example.

Below we have an Excel spreadsheet that has a pivot table on the sheet called "Pivot Table". We've set up a named range called team_count that references this pivot table ('Pivot Table'!$A:$C).

Microsoft Excel

=GetPivotData (team_count,"'Team 1' 'Count of B'")
Result: 1

=GetPivotData (team_count,"'Team 2' 'Count of B'")
Result: 3

=GetPivotData (team_count,"'Team 2' 'Count of C'")
Result: 12
Share on: