GETPIVOTDATA used in an array?

[aaronglover]

Hey Everyone,

Quick question. Is it possible to use a range of cells as one of the field criterias in a GETPIVOTDATA functions. What I am trying to do as an example is return the sum of some pivot fields based on the contents of four different cells. So....would return the sum of the duration field if the contract equaled one of the values in the four referenced cells.

I know I could probably use sum(if( arrays and accomplish the same thing but in my experience that would be far more inefficient.

Any thoughts?

Thanks