81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.

How To Use in Sheets

GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]

External Links

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.