Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
GETPIVOTDATA
GETPIVOTDATA retrieves a value from a PivotTable by specifying the data field to return and one or more field-item pairs that identify the exact cell. It is more robust than cell references because it continues to work correctly even when the PivotTable layout changes. Use it to pull PivotTable figures into summary dashboards.
Topic:Pivot-style summaries (formula approach)Excel
=GETPIVOTDATA("Sales",$A$1,"Region","East")Google Sheets
=GETPIVOTDATA("Sales",$A$1,"Region","East")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1"Sales" is the data field name whose value you want to retrieve from the PivotTable.
- 2$A$1 is a reference to any cell inside the PivotTable — it tells Excel which PivotTable to query.
- 3"Region","East" is a field-item pair that filters the result to the East region row.
More on Pivot-style summaries (formula approach)
See all →How-to
How to build a pivot-style summary with formulas
Build a formula-driven pivot-style cross-tab in Excel or Google Sheets using SUMIFS with mixed references — live totals by row and column without inserting a pivot table.
How-toHow to build a pivot-style summary with QUERY
Use Google Sheets QUERY with GROUP BY, SUM, and LABEL to build a pivot-style summary table without a manual pivot table — Excel alternative uses SUMIFS.
How-toHow to use GETPIVOTDATA to pull values from a pivot table
Learn how GETPIVOTDATA extracts specific values from a pivot table in Excel and Google Sheets, avoiding broken references when the pivot refreshes.
How-toHow to write formulas for a pivot table calculated field
Understand how pivot calculated fields work and when to replace them with SUMIFS-based formulas in Excel and Google Sheets for more control and flexibility.
How-toHow to calculate percent of total without a pivot table
Use SUMIF and SUM to calculate each category's percent of grand total in Excel and Google Sheets — no pivot table required.
How-toHow to group data by month using formulas instead of a pivot
Group and sum transaction data by month using SUMIFS with EOMONTH or TEXT in Excel and Google Sheets — no pivot table needed.