Pivot Table Formula Generator
Describe which value you need to pull from your pivot table in plain English and get a ready-to-use GETPIVOTDATA formula for Excel or Google Sheets.
5 free tries without an account
GETPIVOTDATA syntax
=GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2, ...])data_field is the name of the value being summarized (e.g. "Sales"), pivot_table is any cell reference inside the pivot table, and each field/item pair narrows the result down to a specific row, column, or filter combination. Formulon writes the exact field/item pairs for you from a plain description of what you want to pull out.
Examples
Pull total sales for one region from a pivot table
=GETPIVOTDATA("Sales",$A$3,"Region","West")"Sales" is the value field being summarized, $A$3 anchors the formula to a cell inside the pivot table, and "Region","West" narrows it down to the West row's total.
Pull a value filtered by region and month together
=GETPIVOTDATA("Sales",$A$3,"Region","West","Month","Jan")Adds a second field/item pair — the result is the Sales total for West specifically in January, matching that exact intersection in the pivot table.
Frequently asked questions
Is GETPIVOTDATA the same as building a pivot table?
No — GETPIVOTDATA doesn't build a pivot table, it pulls one specific summarized value out of a pivot table that already exists elsewhere in the workbook, so you can reference it from a regular cell.
Why did Excel turn my simple cell reference into GETPIVOTDATA automatically?
Excel does this automatically when you click a cell inside a pivot table while building a formula, so the reference still points to the right summarized value even if the pivot table is resorted, filtered, or rearranged later.
How do I stop Excel from auto-inserting GETPIVOTDATA?
Go to File > Options > Formulas and uncheck "Generate GetPivotData", or toggle it from the pivot table's Analyze/PivotTable Analyze ribbon (Options dropdown > Generate GetPivotData). This makes clicking a pivot cell insert a plain =A3-style reference instead.
Does GETPIVOTDATA work in Google Sheets?
Yes, Google Sheets supports GETPIVOTDATA with the same argument structure as Excel, once you have a pivot table already built on the sheet.
Don't want to write it by hand?
Describe what you need in plain English and get a ready-to-use formula in seconds.
Try the formula generator