SUM Pivot Table Range

[dluhut]

Hello,

I am wondering if there's a formula that I can sum the range of a pivot table.

I am trying to use SUM(GETPIVOTDATA(...)), but don't know how.

And I've attached a sample

[FlameRetired]

I don't know how GETPIVOTDATA would work for what you want to do. But try this in J2 and fill down.

Please Login or Register  to view this content.

[sandy666]

you can use GETPIVOTDATA with SUM() or simply +

Please Login or Register  to view this content.