GetPivot table 91 + will not work

[howard]

I have a pivot tale & am trying to use =getpivottable to extract the value of 91 + in Col G

=SUM(GETPIVOTDATA(A4,("*91 +*")))

I get N/A#, even though thereare value in this column. The previous column 60-90 works perfectly when using = getpivottable


It would be appreciated if someone could amend my formula

 

[RoryA]

Pretty hard to do without seeing the pivot. GETPIVOTDATA returns only one value unless you pass an array of criteria, so why do you have SUM in there?

 

[howard]

Hi Rory


I used =sum(GETPIVOTDATA) as I need to add an use an array of criteria

See link below of sample data

https://www.dropbox.com/s/zzhl7ct1boldtga/Get Pivottable.xlsm?dl=0


Kindly amend my Formula so I can see where I went wrong

 

[howard]

Hi Rory


Have resolved the issue


I used :

=GETPIVOTDATA(A4,">90")